EXCEL Question - Total negitive values ONLY

[tekjock]

I have a sheet that has 7 cells I want to total. But only total them when they are negitive values. for example, If the 7 cells are "1,0,-1,2,-2,3,-1" I want it to come back and give a positive result of 4 (only totaling the -1,-2,-1). is this possible.
thanks
Tekjock

 

[GlennUK]

Have a SUMIF and negate the answer:

=-SUMIF(myrange,"<0")

replacing myrange with whatever range is required to be summed.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[tekjock]

SCHWEET .. thank you