sun function

[tom]

"how do i sum positive and negative values separately"
so i end up with two totals of a column

 

[Paul Corrado]

Tom,

=SUMIF(range,"<0")
=SUMIF(range,">0")

HTH

PC

 

[Dan E]

Pretend your data is in A1:A100
=SUMIF(A1:A100,">0")
=SUMIF(A1:A100,">0")

Dan E