Prev: Picture protection
Next: If statement linking data from one sheet to another
From: Anri on 27 May 2010 15:53
How do I get to add up only the values > than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0
From: Jacob Skaria on 27 May 2010 15:53
Use SUMIF()

=SUMIF(Q8,">0")

or

=SUMIF(A1:A10,">0")

--
Jacob (MVP - Excel)


"Anri" wrote:

> How do I get to add up only the values > than 0?
>
> Only count: =((Q8)*0.5)+(Q8) .... if larger than 0
From: Jacob Skaria on 27 May 2010 17:11
OR use MAX() as below

=MAX(0,Q8)

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

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

> Use SUMIF()
>
> =SUMIF(Q8,">0")
>
> or
>
> =SUMIF(A1:A10,">0")
>
> --
> Jacob (MVP - Excel)
>
>
> "Anri" wrote:
>
> > How do I get to add up only the values > than 0?
> >
> > Only count: =((Q8)*0.5)+(Q8) .... if larger than 0
 | 
Pages: 1
Prev: Picture protection
Next: If statement linking data from one sheet to another