ExcelBanter - How to add all positive and negative numbers?

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

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

- - How to add all positive and negative numbers? (https://www.excelbanter.com/excel-worksheet-functions/56298-how-add-all-positive-negative-numbers.html)

Knold10

How to add all positive and negative numbers?

I am doing a template regarding standard usage of an item. It has negative
and positve standard usage. How can i add all negative?

Peo Sjoblom

How to add all positive and negative numbers?

=SUMIF(A1:A100,"<0")

--
Regards,

Peo Sjoblom

(No private emails please)

"Knold10" wrote in message
...
I am doing a template regarding standard usage of an item. It has negative
and positve standard usage. How can i add all negative?

All times are GMT +1. The time now is 10:45 AM.