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

Flipping numeric values 3
Coloring cells 8
Change the sign on all numbers in a spread sheet 2
Creating a waterfall chart 1
Help with positive and negative numbers 1
Negative Numbers 8
Columns negative to positive 2
Trying to reconcile a column 1

Top