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

Cumulative formula for word table 0
Program buttons to create a word document 0
Changing row background from external program 0
Negative value to positive 13
Template with fields and premade texts.. 0
Excel - Adding positive or negative numbers in a column 5
IF Statement accepting only positive values 1
Coloring cells 8

Top