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",B2:D10)
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

Try it like this:

=SUMPRODUCT((A2:A10="a")*B2:D10)

--
Biff
Microsoft Excel MVP


"tuafc" wrote in message
...
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",B2:D10)
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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tuafc" wrote in message
...
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",B2:D10)
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