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.