You want the SUMIF function.

For positive values: =SUMIF(A1:A10,"0")

For negative values: =SUMIF(A1:A10,"<0")

--
Rick (MVP - Excel)


"Daniel Collison" wrote in
message ...
I have a list of values, some of which are positive and some are negative.
I
want to sum all positive values in the list, and all negative values in
the
list.

Is anyone aware of a function that allows me to do this?

Thanks,