How do I get to add up only the values > than 0?

Anri · May 27, 2010

How do I get to add up only the values > than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0

Jacob Skaria · May 27, 2010

OR use MAX() as below

=MAX(0,Q8)

=(MAX(0,Q8)*0.5)+MAX(0,Q8)