Source: mpec.sc.mahidol.ac.th
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: A3
1
2
-1
I want my answer to be 4, sum(a1:a3) will return 2.
Bill
Answer:
Hello
= SUMPRODUCT (ABS(A1:A3))
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments