SUMIF using a multiple-column range

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Combine Sumif and Countif 3
SUMIF function help 4
SUMIF data that falls within a range 3
Help with Formula for................. 5
Using SUMIF inside SUMPRODUCT => complex problem (suite) 1
Sum number range ignoring numbers formatted as text 0
using sumif & countif to sort multiple cells 3

Top