summing only positive or negative values
 

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,

summing only positive or negative values
 

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,