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

  • Thread starter Thread starter DR
  • Start date Start date
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.
 
For positive values: =SUMIF(A1:A1000,">0")

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

Adjust the ranges to suit your conditions.
 
Back
Top