Adding positive and negative

[Guest]

Is there a formula I can use to add up all the positive numbers and one to
add up all the negative ones?

 

[Carim]

Hi,

=SUMIF(A1:A100,"<0")
and
=SUMIF(A1:A100,">0")

HTH
Cheers
Carim