COUNTIF non blank cells

laura.sandoval

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]))

ker9

If you need to specify count numbers then:

=COUNTIF([Column Name]:[Column Name], ISNUMBER(@cell))

ker9

Hi @laura.sandoval

If you do not need to specify anything other than not blank, use Count. It only counts non blank cells.

=Count(RANGE)

Hope this helps!

ker9

If you need to specify count numbers then:

=COUNTIF([Column Name]:[Column Name], ISNUMBER(@cell))

laura.sandoval

Ahhh it worked thank you so much!