How to count cells with BLANK value in a column

Options
Hawk
Hawk ✭✭✭
edited 12/09/19 in Formulas and Functions

Say that I want to count how many cells with BLANK in a column? The column have many NOT BLANK values also. eg. ([Col]2 with BLANK value)

          Col

row_1  a

row_2   

row_3  a

....

row_n  a

so the column has 1 cell with BLANK, the count will be 1.

How to write a formula to get the count?

Thanks!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!