Does SumIf work with a range?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matthew.turner@gmail.com - 08 Jan 2007 12:43 GMT

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.

Reply to this Message

Bob Phillips - 08 Jan 2007 13:18 GMT

Try

=SUMPRODUCT((A1:A10="a")*B1:D10)

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

>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.

Reply to this Message