FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN
 

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

Try...

=SUMPRODUCT(ABS(A1:A100))

Hope this helps!

In article ,
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.

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.

A GREAT BIG THANK YOU.......................

"Domenic" wrote:

Try...

=SUMPRODUCT(ABS(A1:A100))

Hope this helps!

In article ,
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.