COUNTIF(...)
Using COUNTIF for non blank cells.
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
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.