# Need Help with Count IF Formula with multiple criteria

1. ## 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.

2. ## 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",""})),"")

3. ## Re: Need Help with Count IF Formula with multiple criteria

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

4. ## 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:
`Please Login or Register  to view this content.`

5. ## Re: Need Help with Count IF Formula with multiple criteria

Thank you all so much!!!!

6. ## Re: Need Help with Count IF Formula with multiple criteria

Glad to help & thanks for the feedback.

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

#### 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