=SUMIF(A2:A100,"0")

=SUMIF(A2:A100,"<0")


or


=SUMPRODUCT(--(C2:C100"Projectx"),--(A2:A1000),A2:A100)

depending on if there are other criteria as well


--
Regards,

Peo Sjoblom



"Johnson31d" wrote in message
...
I am trying to find costs associated with certain project numbers and do
two
different things. One, sum the positive numbers, and two, sum the
negative
numbers. I have been able to use the array formula SUM(IF(......)).
However, I am having trouble separating the positive from the negative
numbers. I need more than just the net total.... HELP!!!