Please enable JavaScript to view the comments powered by Disqus.


Counting cell that are not blank in a given cell range.

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. 

Used Functions

Category: Statistical

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


COUNTIF(range, criteria)

Lets chat on this