Hai How to sum in a column only a positive and negative value separetly rgds
B Bernard Liengme Feb 21, 2009 #2 Positive values only: =SUMIF(A1:A20,">"&0) Negative values only: =SUMIF(A1:A20,"<"&0) best wishes
F Fred Smith Feb 21, 2009 #4 If it's the whole column you want to sum, use: =sumif(a:a,">0") =sumif(a:a,"<0") Regards, Fred.
