Sum a range but exclude and negative values

[lister_d_000169]

I am looking to sum a range of cells but not include in the sum any negative values.

Thus far all that i could think of doing was a round about way via the ABS and the SUM functions but was looking to see if there was a function that would do the whole job lot in one go!!

[Marcelo]

sumif(range;">0")

Regards from Brazil
Marcelo

"lister_d_000169" escreveu:

>
> I am looking to sum a range of cells but not include in the sum any
> negative values.
>
> Thus far all that i could think of doing was a round about way via the
> ABS and the SUM functions but was looking to see if there was a
> function that would do the whole job lot in one go!!
>
>
> --
> lister_d_000169
> ------------------------------------------------------------------------
> lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
> View this thread: http://www.excelforum.com/showthread...hreadid=547430
>
>

[[email protected]]

=SUMIF(RangeToSum,">0")

will do it for you
lister_d_000169 wrote:
> I am looking to sum a range of cells but not include in the sum any
> negative values.
>
> Thus far all that i could think of doing was a round about way via the
> ABS and the SUM functions but was looking to see if there was a
> function that would do the whole job lot in one go!!
>
>
> --
> lister_d_000169
> ------------------------------------------------------------------------
> lister_d_000169's Profile: http://www.excelforum.com/member.php...o&userid=32950
> View this thread: http://www.excelforum.com/showthread...hreadid=547430