Summation of +ve -ve numbers

[Ajinkya]

Dear Friends,


Could you suggest,

How can I calculate what is the summation of all +ve numbers & all -ve numbers in the specific column.


E.G.

A1=20

A2=30

A3=-10

A4=-35

A5=54

A6=60

A7=-34

A8=85


C1=249 (Summation of all grater than zero numbers in column A)

D1=-79 (Summation of all less than zero numbers in column A)


Thanks

 

[Luke M]

All positive

=SUMIF(A:A,">0")


All negative

=SUMIF(A:A,"<0")

 

[Ajinkya]

great, thanks a lot Ninja

 

[Luke M]

You're very welcome, thanks for the feedback.