S
skygazer
How do I add only the positve numbers in a column with both positive and
negative numbers?
negative numbers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Try
=SUMIF(A:A,">0")
=SUMIF(A:A,">0")
B
Bernard Liengme
=SUMIF(A1:A100,">0") will sum the poisitve values
=SUMIF((A1:A100,"<0") will sum the negative ones
best wishes
=SUMIF((A1:A100,"<0") will sum the negative ones
best wishes
F
FSt1
hi
try this....
=SUMIF(A1:A100,">0")
regards
FSt1
try this....
=SUMIF(A1:A100,">0")
regards
FSt1
J
Jeff
=SUMPRODUCT((A1:A15)*(A1:A15>0))
A1:15 represents whatever your range is.
I like sumproduct because it is intuitive, showing you your conditions, ie
greater than zero or positive.
A1:15 represents whatever your range is.
I like sumproduct because it is intuitive, showing you your conditions, ie
greater than zero or positive.
J
Jim Thomlinson
Use SimIf
=SUMIF(A1:A10, ">0", A1:A10)
=SUMIF(A1:A10, ">0", A1:A10)