Try this
=SUM(IF(A1:A150,A1:A15,FALSE))

enter with Ctrl+shift+enter
reverse the sign to get < 0

Mike

"Mike Busch" wrote:

I have a coulmn with both negative and positive numbers. I would like a
formula that will add up only the positive or one that will add up only the
negitive numbers. Thanks in advance.