ExcelBanter - FORMULA WHICH IGNORES POSITIVE VALUES

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - FORMULA WHICH IGNORES POSITIVE VALUES (https://www.excelbanter.com/new-users-excel/209087-formula-ignores-positive-values.html)

CHAKES

FORMULA WHICH IGNORES POSITIVE VALUES

HI
I NEED KNOW IF THERE'S A SUM FORMULA {=SUM(A1:A4)} WHICH TOTALLY IGNORES
POSITIVE VALUES AND ADDS ONLY THE NEGATIVE VALUES?

EXAMPLE:
A1= -3
A2= -7
A3= 2
A4= -6
A5= ANSWER WHICH IS OBVIOUSLY -14, BUT I WANT THE FORMULA TO IGNORE THE 2 SO
THE ANSWER WOULD BE -16.

Sandeep Jangra[_2_]

FORMULA WHICH IGNORES POSITIVE VALUES

Hi,
Use =SUMIF(A1:A4,"<0")

"CHAKES" wrote:

HI
I NEED KNOW IF THERE'S A SUM FORMULA {=SUM(A1:A4)} WHICH TOTALLY IGNORES
POSITIVE VALUES AND ADDS ONLY THE NEGATIVE VALUES?

EXAMPLE:
A1= -3
A2= -7
A3= 2
A4= -6
A5= ANSWER WHICH IS OBVIOUSLY -14, BUT I WANT THE FORMULA TO IGNORE THE 2 SO
THE ANSWER WOULD BE -16.

Billy Liddel

FORMULA WHICH IGNORES POSITIVE VALUES

Any of the following:
=SUMPRODUCT(--(A1:A4<0)*(A1:A4))
=SUMIF(A1:A4,"<0",A1:A4)

=SUM(IF(A1:A4<0,A1:A4))

The last is an array formula and must be committed with Ctrl + Shift + Enter
(CSE)

Peter Atherton

"CHAKES" wrote:

HI
I NEED KNOW IF THERE'S A SUM FORMULA {=SUM(A1:A4)} WHICH TOTALLY IGNORES
POSITIVE VALUES AND ADDS ONLY THE NEGATIVE VALUES?

EXAMPLE:
A1= -3
A2= -7
A3= 2
A4= -6
A5= ANSWER WHICH IS OBVIOUSLY -14, BUT I WANT THE FORMULA TO IGNORE THE 2 SO
THE ANSWER WOULD BE -16.

All times are GMT +1. The time now is 07:53 AM.