Please enable JavaScript to view the comments powered by Disqus.


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

How to COUNTIF() values greater then zero.

The COUNTIF() formula takes two arguments: first is the lookup range and the second is the lookup criteria, For this case we are looking for cells with values greater 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