Please enable JavaScript to view the comments powered by Disqus.


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

How to count cell that are not blank

We will use COUNTIF function with logical criteria "<>" i.e. other then and count the non blank cell.


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