=sumif(a1:a10,""&0)
=sumif(a1:a10,"<"&0)

You may want to add =countif() to do some checking:

=if(countif(a1:a10,""&0)=0,"No Positives",sumif(a1:a10,""&0))


Johnson31d wrote:

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!!!

--

Dave Peterson