Please enable JavaScript to view the comments powered by Disqus.


SUMIF(...(...B4:B15),(...">"&B17))

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

Syntax

SUMIF(range, criteria, [sum_range])

Lets chat on this