CODEWITHSUNDEEP
google-sheets
Travis Christianson
Travis Christianson

Reputation: 150

Google Sheet SUMIF with IMPORTRANGE

I'm trying to create a SUMIF using IMPORTRANGE but apparently that cannot be done in Google Sheets. How else can I create the following and have it work in Google Sheets?

=SUMIF(IMPORTRANGE("URL","SHEET1!$A:$A"),$E:$E,SHEET1!$H:$H)

Upvotes: 1

Views: 1510

Answers (1)

Travis Christianson
Travis Christianson

Reputation: 150

I was able to fix this myself using the following formual:

=IF(A2 = "","",IFERROR(SUM(QUERY(IMPORTRANGE("URL", "SHEET1!$A:$H"),"select Col8 where Col1 = '"&$E2&"'",0)*-1)))

Upvotes: 1

Related Questions