Need help with a countif or Sum formula

[bossbarnes07]

Is there a way to count the following with a formula. I'm attempting to count all the cells with the following SN in it, all conditions are counted accept for the combinations that has PT or OT in it. I have attached a worksheet to this file. Thanks

[NBVC]

Try:

=COUNTIFS(A:A,"*SN*",A:A,"<>*PT*",A:A,"<>*OT*")

[bgoree09]

Good morning,

I apologize if I'm not understanding correctly, but if you want to find a count of all the items that contain "SN" you can use this:

=COUNTIF(A:A,"*SN*")

Or, of you want all the SN's that are not paired with PT or OT you can use:

COUNTIFS(A:A,"*SN*",A:A,"<>*PT*",A:A,"<>*OT*")

Hope this helps. Best of luck,