How to count cells with a value in a column

Hello,

Trying to figure out how to count cells with values in one column. For example:

I want to know how many cells contain a value on the following:

Column 2

Josh

Robert

Alexandra

Greg

My ideal answer would be that there are 4 values in column 2.

Any idea what the formula is for this?


I have the formula for blank cells:

=COUNTIF([Column2]2:[Column2]11, " ")


Thanks!


Elisa

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!