ExcelBanter - Adding positive and negative

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Adding positive and negative (https://www.excelbanter.com/excel-programming/375642-adding-positive-negative.html)

TheRook

Adding positive and negative

Is there a formula I can use to add up all the positive numbers and one to
add up all the negative ones?

Carim

Adding positive and negative

Hi,

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

HTH
Cheers
Carim

All times are GMT +1. The time now is 06:57 AM.