| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMIF using a multiple-column range
I have a very simple task and I don't get why SUMIF isn't doing what I expect
it to. Observe this set of data: 1 15 4 0 3 2 1 1 8 If I do SUMIF(A1:A3,"=1",B1:C3) then I just get 16, which is the result of SUMIF(A1:A3,"=1",B1:C3), rather than 28, which is the sum of 15+4+1+8. I realize that I could do SUMIF(A1:A3,"=1",B1:B3) + SUMIF(A1:A3,"=1",C1:C3), but that just seems silly, since SUMIF takes in a Range, I don't get why it doesn't actually sum over the range. And yes I have tried using Ctrl+Shift+Enter when entering it, no help. |
|
#2
|
|||
|
|||
|
Try...
=SUMPRODUCT((A1:A3=1)*B1:C3) Hope this helps! In article , "Stefan Wrobel" wrote: I have a very simple task and I don't get why SUMIF isn't doing what I expect it to. Observe this set of data: 1 15 4 0 3 2 1 1 8 If I do SUMIF(A1:A3,"=1",B1:C3) then I just get 16, which is the result of SUMIF(A1:A3,"=1",B1:C3), rather than 28, which is the sum of 15+4+1+8. I realize that I could do SUMIF(A1:A3,"=1",B1:B3) + SUMIF(A1:A3,"=1",C1:C3), but that just seems silly, since SUMIF takes in a Range, I don't get why it doesn't actually sum over the range. And yes I have tried using Ctrl+Shift+Enter when entering it, no help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print 3 column range in six columns | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Sumif over multiple columns | Excel Worksheet Functions | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
