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

how do I sum up column values 3
Multiple IF Statement in Word 5
Calculate the median value before a specified list 0
formula for arriving net difference 0
Autonumber field in Excel that behaves the same as Access 0
series of formulas to get to one formula 0
Sum Values from different column 1
Drop down list control value in vba 2

Top