Google Sheets: SUMIF returns "Argument must be a range" error

[Michelleaneous]

The aim is to get the sum from another file based on a criteria from the "main" sheet. Importrange function was used to retrieve data from the other file (see formula below) but it will give an error message: "Argument must be a range"

=SUMIF(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iKwpbmnGuNBk7QJwi3m6RyKZXZ3fWexK/edit#gid=1466490795","Sheet1!A2:A"),B43,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1iKwpbmnGuNBk7QJwi3m6RyKZXZ3fWexK/edit#gid=1466490795","Sheet1!E2:E))"))

 

[etaf]

this may not be relavant, as not sure of the importrange
BUT
you have
"Sheet1!A2:A"
so not a range
"Sheet1!A2:A10000"
is a range - is that why you have the error

"Argument must be a range"​

 

[Michelleaneous]

this may not be relavant, as not sure of the importrange
BUT
you have
"Sheet1!A2:A"
so not a range
"Sheet1!A2:A10000"
is a range - is that why you have the error

"Argument must be a range"​

updated the range as suggested above but still get the same error

 

[carlogovich]

COULD YOU SOLVE THIS ISSUE

 

[RoryA]

IMPORTRANGE returns an array and SUMIF requires actual ranges on a sheet. You'd have to return the IMPORTRANGE results to a sheet and then refer to those cells in the SUMIF formulas.

 

[carlogovich]

It seems that this formula doesn´t work when you retrieve the data from an external Google Sheets file, but I've tried this formula instead and it worked for me:

=SUM(FILTER(IMPORTRANGE($D$2, "C2. Pagos S10!$G$4:$G"), IMPORTRANGE($D$2, "C2. Pagos S10!$A$4:$A") = K$7))