COUNTIFS on the same column and COUNTIFS on other columns

Lori Khoury

Hi 

I am trying perform the COUNTIFS function and can't get this to work.  So what I need to count is the following

1. Count if criteria is "s" in the function column
2. Count if criteria is "Med" in the priority column
3. Count if criteria is "No" in the project column 
4. And from the same project column I need to count if criteria is "partial" also.

My formula has step 1-3 but I can't figure out how to include step 4.

=COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "No")

Any chance someone knows how to do this?  Criteria from multiple columns and then 2 criteria from the same column.

Any help would be greatly appreciated.

 

Thanks

ricki

How can your project field say both No and partial at the same time? That may be the issue here? are you trying to count if it either has the word no or the word partial?

 

Did you try?

=COUNTIFS(Functions2:Functions290, "s", Priority2:Priority290, "Med", Project2:Project290, "No",Project2:Project290, "partial")