I'm working on a spreadsheet in which one column has both negative and positive number. Below the column I would like a sum of the absolute values of those figures I tried this formula but it didn't work. =sum(abs(A1:a5)) I also tried =sum(abs(a1):abs(a5)). Any ideas.. Please help.
-Danny
-Danny