Does SumIf work with a range?

[matthew.turner]

I thought you could Sumif on a whole range, ie if A1 to A10 was your
criteria range, and B1 to D10 was the range from which to sumif.
However it only seems to sum what is in B1 to B10. Is that right?

I know I could use an array formula, but that might be a bit complex
for the recipient of the file.

 

[Bob Phillips]

Try

=SUMPRODUCT((A1:A10="a")*B110)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)