Please enable JavaScript to view the comments powered by Disqus.


COUNTIF(...B4:B13,(..."<>"&""))

Countif if not a blank cell 

The second argument of the functions takes a logical operator of other then that checks for the blank cell. The function thus gives the non-blank cell count.


Used Functions

Category: Statistical

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

Syntax

COUNTIF(range, criteria)

Lets chat on this