ExcelBanter - Adding only the negative or positive numers in a column or row

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding only the negative or positive numers in a column or row (https://www.excelbanter.com/excel-discussion-misc-queries/117883-adding-only-negative-positive-numers-column-row.html)

slowes

Adding only the negative or positive numers in a column or row

How do I add only the negative or only the positive numbers in a selected
range?

MrAcquire

Adding only the negative or positive numers in a column or row

To sum negative numbers only in a selected range,

=SUMIF(range,"<0")

To sum positive numbers only in a selected range,

=SUMIF(range,"0")

"slowes" wrote:

How do I add only the negative or only the positive numbers in a selected
range?

Jaleel

Adding only the negative or positive numers in a column or row

Hi,

In another cell put

=SUMIF(range,"<0") to get the total of negative numbers and
=SUMIF(range,"0") for the total of positive numbers.

Regards,

Jaleel

"slowes" wrote:

How do I add only the negative or only the positive numbers in a selected
range?

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