Add a second hidden column the takes the square root of a square....
Or "=ABS(cell)
Then in your total cell have in add up that hidden column.

"JON" wrote:

LOOKING FOR A FORMULA THAT WILL ADD NUMBERS IN A COLUMN, REGARDLESS OF THEIR
SIGN. I DO NOT WANT NEGATIVE NUMBERS TO BE SUBTRACTED.