Try:
=COUNTIFS(A:A,"*SN*",A:A,"<>*PT*",A:A,"<>*OT*")
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
Try:
=COUNTIFS(A:A,"*SN*",A:A,"<>*PT*",A:A,"<>*OT*")
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,
Bookmarks