Adding only positive cells

[Timo]

HI
What formula would work to return the SUM of only positive cells.
i.e. in (B2:B8) cells B5 has -65.00 the rest cells has figures more than 1.
and I do not want the -65 to be added in the sum.
Any idea?

Thanks

 

[Bill Kuunders]

=SUMIF(B2:B8,">0")
regards
Bill K

 

[Don Guillett]

Have a look in HELP index for SUMIF

 

[Sandy Mann]

Try

=SUMIF(B2:B8,">0")

HTH

Sandy

 

[Timo]

Thanks Guys
SUMIf thats what I needed.
Thanks