Help with Formula

M

Mike Busch

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

Mike H

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

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

Mike
 
P

Per Jessen

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
 
B

BoniM

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

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

Adust range as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Adding positive or negative numbers in a column 5
Adding only negative numbers in row 3
Help with positive and negative numbers 1
Help with formula 3
Coloring cells 8
Delete all negative numbers leaving only positive numbers 8
Negative Numbers 8
Need help with frequency formula 2

Top