If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SUMIF Problem
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 |
#2
|
|||
|
|||
SUMIF Problem
Try it like this:
=SUMPRODUCT((A2:A10="a")*B210) -- 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",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 |
#3
|
|||
|
|||
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",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 |
Thread Tools | |
Display Modes | |
|
|