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