COUNTIF(...)
Counting cell that are not blank in a given cell range.
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
We will use "<>" to represent the condition "other then" and then will look into the range for the given criteria and then COUNTFI will return the final count.