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
    Mississauga, Canada
    Excel Version
    Excel 2016


  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:


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


    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