# 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.  Register To Reply

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",""})),"")  Register To Reply

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  Register To Reply

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.`  Register To Reply

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

Thank you all so much!!!!  Register To Reply

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

Glad to help & thanks for the feedback.  Register To Reply