Count If and Not blank
Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria.
The columns are:
Responsible Department - I want to count the cells in this column that are not blank
Program Name - Here is the Criteria - I want to count the cells in the Responsible Department column if the cell in this column matches "USP"
I have looked through the forums and can't seem to find a formula that would work (or one that I am doing right :) )
Thanks in advance for any help!
Help Article Resources
Check out the Formula Handbook template!