View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CHAKES CHAKES is offline
external usenet poster
 
Posts: 1
Default 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.