Ignoring Negative Values

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.

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

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

Greetings from New Zealand
Bill K

"solomon_monkey" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

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