Need for an absolute sum formula

Office

Question:I need a formula which will be the sum of the absolute values of cells (76 k pass 300 lines x which makes hard ABS() each cell) meaning:I have the following text in cells A1: A312-1I want my answer to be 4, sum(a1:a3) will return 2.BillAnswer:Hello= SUMPRODUCT (ABS(A1:A3))Read More

Posted: 22 Feb 2012

Tags: Need for an absolute sum formula Need for absolute sum formula