Need help with a countif or Sum formula

bossbarnes07

New member
Joined
Jun 27, 2014
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • demo_info.xls
    487.5 KB · Views: 22

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

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

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
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,
 
Top