Please enable JavaScript to view the comments powered by Disqus.


How to sum values greater then zero. 

We will use sumif with a logical operator to check for values greater then given values, and the respective values are summed to get the answer.

Used Functions

Category: Math and trigonometry

Adds the cells specified by a given criteria


SUMIF(range, criteria, [sum_range])

Lets chat on this