Please enable JavaScript to view the comments powered by Disqus.


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

Countif criteria example with condition greater then zero

The COUNTIF function is used to count times a value falls in given criteria, one of its variation is to count for values zero then zero. 


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