Home > Blockchain >  Filter and Importrange not accepting multiple criteria in Google Sheets
Filter and Importrange not accepting multiple criteria in Google Sheets

Time:03-17

I'm trying to use this formula but the last IMPORTRANGE criteria is not working:

Formula:

=IFNA(filter(SUMIFS(IMPORTRANGE("URL","GA_Base!C:C"),IMPORTRANGE("URL","GA_Base!A:A")=H77), IMPORTRANGE("URL","GA_Base!B:B")="DP"))

This is the criteria that is not working:

IMPORTRANGE("URL","GA_Base!B:B")="DP"

Am I doing something wrong because it's multiple criteria?

CodePudding user response:

try:

=IFNA(INDEX(SUMIFS(IMPORTRANGE("URL", "GA_Base!C:C"),
                   IMPORTRANGE("URL", "GA_Base!A:A")=H77, 
                   IMPORTRANGE("URL", "GA_Base!B:B")="DP"))

CodePudding user response:

Try making a brand new tab on your spreadsheet and place this in cell A1:

=QUERY(IMPORTRANGE("URL", "GA_Base!A:C"),"select Col1,SUM(Col3) where Col2 = 'DP' group by Col1",0)

then use the table that makes for some regular vlookups on the tab in question for your values in column H.

  • Related