FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN

J

JON

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

Mike

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.
 
Top