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.