Excel - Adding positive or negative numbers in a column

S

skygazer

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

Bernard Liengme

=SUMIF(A1:A100,">0") will sum the poisitve values
=SUMIF((A1:A100,"<0") will sum the negative ones
best wishes
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement accepting only positive values 1
Adding Negative and Positive Numbers 4
Negative Numbers 8
Possible to Combine reports to's to a single box? 0
Coloring cells 8
Help with positive and negative numbers 2
Negative value to positive 13
Creating a waterfall chart 1

Top