Ignoring Negative Values

S

solomon_monkey

Like all things in Excel there must be a way...

Given a column of numbers (say for simplicity 5 numbers) how can you
use a formula to sum them and ignore any that are negative? (e.g. four
of our 5 numbers are 5 and the other is -5 I want my formula to display
20 and not 15 or 25).

Thanks.
 
D

dominicb

Good morning Solomon_monkey

You can do it, using the SUMIF function, and basically just add numbers
that are greater than zero, thus:

=SUMIF(A1:A10,">0",A1:A10)

Your post didn't specify what range you were working on so my example
uses the range A1:A10.

HTH

DominicB
 
S

solomon_monkey

You are all wonderful. Thanks.

And to Bill K I look forward to visiting Middle Earth at some point.
Apparently they still haven't taken down the scenery!!
 
Top