summing only positive or negative values

[Daniel Collison]

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,

 

[Rick Rothstein]

You want the SUMIF function.

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

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

 

[Daniel Collison]

Thanks...it's exactly what I was looking for. Daniel