SUMIF Problem

[tuafc]

I am on Excel 2003 and having difficulty with a seemingly simple function.

Month 1 Month 2 Month 3
a 10 100 1000
b 20 200 2000
c 30 300 3000

I want to sum the values where the row matches a. I have in place the
following formula:
=SUMIF($A$2:$D$10,"a",B210)
but it only returns 10, not 1110 as I expected. How can I get it to sum my
range across the columns and not just give me the first value?

Many thanks

 

[T. Valko]

Try it like this:

=SUMPRODUCT((A2:A10="a")*B210)

 

[Don Guillett]

=SUMPRODUCT(($a$2:$a$10="a")*b2:d10)