Ignoring Negative Values

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

 

[Bill Kuunders]

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

Greetings from New Zealand
Bill K

 

[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

 

[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!!