SUm

[shah]

Hai

How to sum in a column only a positive and negative value separetly

rgds

 

[Bernard Liengme]

Positive values only: =SUMIF(A1:A20,">"&0)
Negative values only: =SUMIF(A1:A20,"<"&0)
best wishes

 

[Fred Smith]

If it's the whole column you want to sum, use:
=sumif(a:a,">0")
=sumif(a:a,"<0")

Regards,
Fred.