How to sum only Nagative or only postive values in a row ?

D

DR

Hi,

Can any one tell me the function/formula for how to sum (Add) only
nagative(-) or only positive (+) values in a row/column.

I have so many # which is mixed with positive and nagative values.
 
R

Rick Rothstein

For positive values: =SUMIF(A1:A1000,">0")

For negative values: =SUMIF(A1:A1000,"<0")

Adjust the ranges to suit your conditions.
 

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

summing only positive or negative values 2
Sum Postitive Values 5
A row of values 3
Sum below a specific row 1
How do I sum cells that have values from a text formula? 4
If sign of sum is negative change to positive 1
making a # value positive or negative based on contents of another 3
subtract a positive from a negative 7

Top