Multiple criterias in SUMIF

NicolaiK

New Member
Joined
Feb 13, 2016
Messages
7
Hi Guys, I cant seem to get this formula the way I need it.

=SUMIF(O:O;"<>INTERN";J:J)

So what I want to do is to add more criterias in addition to "<>INTERN"... probably real easy, but onfortunately Im not that Excel savvy.

Can anyone help?

-Nic
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

BadlySpelledBuoy

New Member
Joined
Apr 20, 2014
Messages
11
Which version of Excel are you using? If later than 2003 then you can use SUMIFS rather than SUMIF.

=SUMIFS(J:J;O:O;"<>INTERN";O:O;"<>X";O:O;"<>Y";O:O;"<>Z")

BSB
 

NicolaiK

New Member
Joined
Feb 13, 2016
Messages
7
Which version of Excel are you using? If later than 2003 then you can use SUMIFS rather than SUMIF.

=SUMIFS(J:J;O:O;"<>INTERN";O:O;"<>X";O:O;"<>Y";O:O;"<>Z")

BSB


Thanks for getting back to me, Im using Office 2016 for Mac. The above formula worked perfectly, thanx!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,013
Messages
5,526,266
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top