# Proper SUMIF Technique

#### kcoon

##### New Member
Does anyone here know why the following formula gives me 0 results (in this formula, the text "Dave" appears in column E):

=SUMIF(C12:E31,"Dave",C12:C31)

Yet, when I move the colum I am evaluating to the left of the sum range I get "55" (now the text is in Column B" -- I just copied and pasted it)

=SUMIF(B12:D31,"Dave",C12:C31)

Can SUMIF only evaluate data to the left of the sum range?

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

#### Nimrod

##### MrExcel MVP
Hello kcoon

=SUMIF(C12:E31,"Dave",C12:C31)
SUMIF(Criteria_range,criteria,sum_range)

You've got the column "Dave" will be found in Overlapping with the column to sum :wink:

What Column is the Name In ?
What Column are the numbers in ?

=SUMIF(E:E,"dave",C:C)
In this example the values to sum are in Column C and the name Dave can be found in Column E .

#### kcoon

##### New Member
Nimrod, I thought I followed your comment about overlapping, but when I don't include Column C in the range I get some funky result (I think it tries to sum Column D).

This is what basically what it looks like now:

Column B Column C Column D Column E

Dave 4 \$10,000 Dave
Charlie 5 \$11,000 Charlie
Frank 6 \$10,500 Frank
Dave 7 \$9,000 Dave

I'm looking for sum = 11 without using column B (if that's possible)

#### Nimrod

##### MrExcel MVP
=SUMIF(E:E,"dave",C:C)
In this example the values to sum are in Column C and the name Dave can be found in Column E .

#### kcoon

##### New Member
That definitely did the trick. Thanks.

Still, I'm slightly perplexed as to why I can specify a range of multiple columns in one instance, =SUMIF(B:D,"Dave",C:C), and not in the other. Is there some basic concept that I'm missing?

Replies
2
Views
188
Replies
6
Views
558
Replies
2
Views
696
Replies
8
Views
123
Replies
1
Views
71

1,195,635
Messages
6,010,823
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back