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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to sum only Nagative or only postive values in a row ? (https://www.excelbanter.com/excel-worksheet-functions/225156-how-sum-only-nagative-only-postive-values-row.html)

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

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.

Rick Rothstein

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

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

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

Adjust the ranges to suit your conditions.

--
Rick (MVP - Excel)

"DR" wrote in message
...
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.

All times are GMT +1. The time now is 01:21 PM.