Multiple criterias in SUMIF

[NicolaiK]

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

 

[BadlySpelledBuoy]

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]

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!

 

[BadlySpelledBuoy]

No problem. Happy to help

BSB