Excel - Adding positive or negative numbers in a column
 

How do I add only the positve numbers in a column with both positive and
negative numbers?

Excel - Adding positive or negative numbers in a column
 

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

--
Jacob (MVP - Excel)


"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?

Excel - Adding positive or negative numbers in a column
 

=SUMIF(A1:A100,"0") will sum the poisitve values
=SUMIF((A1:A100,"<0") will sum the negative ones
best wishes
--
www.stfx.ca/people/bliengme


"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?

Excel - Adding positive or negative numbers in a column
 

=SUMPRODUCT((A1:A15)*(A1:A150))

A1:15 represents whatever your range is.

I like sumproduct because it is intuitive, showing you your conditions, ie
greater than zero or positive.

"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?

Excel - Adding positive or negative numbers in a column
 

hi
try this....
=SUMIF(A1:A100,"0")

regards
FSt1

"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?

Excel - Adding positive or negative numbers in a column
 

Use SimIf

=SUMIF(A1:A10, "0", A1:A10)
--
HTH...

Jim Thomlinson


"skygazer" wrote:

How do I add only the positve numbers in a column with both positive and
negative numbers?