How to count cells with a value in a column
Options
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
-
"Not Equal To" is <>. So you would use that to say "not equal to blank".
=COUNTIFS([Column2]2:[Column2]11, <> "")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!