COUNTIF non blank cells

I created a dashboard metrics sheet that is referencing data from various sheets using columns and I am stuck! I would like to have a metric for a column in a sheet that will count all of the sites that have a number assigned to them, some cells are blank and I only want the ones with a number.

How can I count all those cells that are not blank? This is what I have and I know I'm totally off....

Reference sheet --> {Master Data Sheet Site Number}

Column Name --> Site Number

=COUNTIF({Master Data Sheet Site Number}, NOT(ISBLANK@[Site Number]))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!