Help with Formula
 

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.

Help with Formula
 

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.

Help with Formula
 

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.

Help with Formula
 

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.

Help with Formula
 

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.