+ Reply to Thread
Results 1 to 6 of 6

Need Help with Count IF Formula with multiple criteria

  1. #1
    Registered User
    Join Date
    01-31-2022
    Location
    USA
    MS-Off Ver
    2016
    Posts
    16

    Need Help with Count IF Formula with multiple criteria

    I have a spreadsheet that I am using to track education for my staff. I have two kinds of staff, nurses and PCT. I have several types of education such as classes, competencies, etc. I need to separate the nurses from the PCT staff, and I need to separate competencies from classes.
    For example, I want to count the competency cells with a blank or an X in cells J4-n4, only if E4 has PCT. Below is the formula I am trying to use.

    =COUNTIFS(J4:N4,"x",J4:N4, "",E4,"PCT")

    This formula gives me the value error.

    Thank you so much in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,648

    Re: Need Help with Count IF Formula with multiple criteria

    Try this:

    =IF(E4="PCT",COUNTIF(J4:N4,"x")+COUNTIF(J4:N4,""),"")

    or this:

    =IF(E4="PCT",SUM(COUNTIF(J4:N4,{"x",""})),"")
    Last edited by AliGW; 05-03-2022 at 09:54 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,083

    Re: Need Help with Count IF Formula with multiple criteria

    Is this what you want
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    although none of those columns contain an X

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,487

    Re: Need Help with Count IF Formula with multiple criteria

    I do not see any x as indicator in J:N, so count empty then:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  5. #5
    Registered User
    Join Date
    01-31-2022
    Location
    USA
    MS-Off Ver
    2016
    Posts
    16

    Re: Need Help with Count IF Formula with multiple criteria

    Thank you all so much!!!!

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,083

    Re: Need Help with Count IF Formula with multiple criteria

    Glad to help & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to count cells with multiple criteria
    By PDBartlett in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-18-2021, 09:59 AM
  2. [SOLVED] Formula to count matches between multiple columns on different sheets w/ multiple criteria
    By RICK JAMES in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2019, 03:28 PM
  3. [SOLVED] Formula to count occurrences, multiple ranges, multiple criteria, with wildcard
    By TMMc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2017, 03:27 PM
  4. Count formula multiple criteria
    By idontexcelinexcel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-08-2015, 07:58 PM
  5. [SOLVED] Multiple Count Criteria Formula
    By jimd1768 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2015, 05:33 AM
  6. [SOLVED] Formula how to count the date with multiple criteria.
    By felixpanganiban in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-04-2012, 10:40 AM
  7. Count formula - multiple criteria
    By martins in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2008, 02:08 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1