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.

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.

Hi Mike

The formulas below will sum positive or negative values in range A1:A10

=SUMIF(A1:A10;"0")
=SUMIF(A1:A10;"<0")

Best regards,
Per

"Mike Busch" skrev i meddelelsen
...
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.

Add only positive:
=SUMIF(B2:B12,"0")

Add only negative:
=SUMIF(B2:B12,"<0")

Adust range as needed.

"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.

Check out the sumif() function.

"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.