I just realized after I posted this that if I add another column next to A
with the same values and do SUMIF(A1:B3,"=1",C1:D3) then I get my intended
result, but is there a way to do this without adding that extra redundant
column? Or is Excel just not smart enough to tell that when you only give it
one column for your criteria to use that for all sum columns. Oh well...

"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.