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

and

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!