=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