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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!