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.
Bookmarks