# SUM/IF Forumlas

#### mgoldie1

##### New Member
This is probably pretty easy, but I can't figure it out. Obviously I can SUM a column. However, I want to SUM the next column (Column D), but I'm trying to SUM column C but ignore any entries that have certain words from Column A (Mom, Dad, and Lisa). How do I put that in a formula for cell D13. Thanks.

Marc

https://www.dropbox.com/s/ffa5lep3otiqf2o/Sum Test.xlsx?dl=0

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
I think the easier way to look at that is that you are only trying to sum the cells that are Free or Bonus:

=SUM(SUMIF(A3:A12,{"Free","Bonus"},D3:D12))

definitely easier what Scott mentioned but if you only know what words not to include then this should work
Code:
``=SUMIFS(B2:B12,A2:A12,"<>Mom",A2:A12,"<>Dad",A2:A12,"<>Lisa")``

Hi,

Assuming OP also wants the "un-categorized" SUMed also:

Book1
ABCD
1TypesTotalsTotals Filtered
24
3Bonus8
4Mom5
6Lisa1
712
8Free5
92
10Bonus3
112
12Mom2
134636
Sheet1
Cell Formulas
RangeFormula

Thanks everyone. That helps a lot!!

Hi,

Assuming OP also wants the "un-categorized" SUMed also:

ABCD
1TypesTotalsTotals Filtered
24
3Bonus8
4Mom5
6Lisa1
712
8Free5
92
10Bonus3
112
12Mom2
134636

</tbody>
Sheet1

Worksheet Formulas
CellFormula

</tbody>

<tbody>
</tbody>

You're welcome.

Replies
2
Views
226
Replies
5
Views
1K
Replies
0
Views
440
Replies
4
Views
338
Replies
1
Views
402

1,214,437
Messages
6,119,520
Members
448,903
Latest member
StephMJ

### 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