Results 1 to 3 of 3

Thread: Need help with a countif or Sum formula

  1. #1

    Need help with a countif or Sum formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Try:

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


  3. #3
    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,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •