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

"Not Equal To" is <>. So you would use that to say "not equal to blank".
=COUNTIFS([Column2]2:[Column2]11, <> "")
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!