Function for summing just positive resp. negative values in a column

[Kribulin]

How can I choose to just sum the positive (respectively just the negative) values of a column containing a mixture of both?

Thanks in advance!

 

[Aladin Akyurek]

how Can I Choose To Just Sum The Positive (respectively Just The Negative) Values Of A Column Containing A Mixture Of Both?

Thanks In Advance!

Try...

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

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

 

[jindon]

=SumIf(A:A,">0")
=SumIf(A:A,"<0")

?

 

[Mike Blackman]

HI,

How about something like this;

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

 

[Kribulin]

Thanks!

Thanks for all the fast responses!