Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |