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