Thread
:
SUMIF Problem
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
SUMIF Problem
=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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett