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

[Anri]

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

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

 

[Jacob Skaria]

OR use MAX() as below

=MAX(0,Q8)

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