Please enable JavaScript to view the comments powered by Disqus.


Using COUNTIF for non blank cells.

COUNTIF can be used to count the non blank cell by adding up "other then' criteria to its criteria argument.  Thus we can have count of non blank cells.

Used Functions

Category: Statistical

Counts the number of cells within a range that meet the given criteria


COUNTIF(range, criteria)

Lets chat on this