You can use the following basic formula to calculate the sum of a range of absolute values in Excel:
This particular formula calculates the sum of absolute values in the range A2:A15.
The following example shows how to use this formula in practice.
Example: How to Sum Absolute Values in Excel
Suppose we have the following list of values in Excel:
We can type the following formula into cell C1 to calculate the sum of the absolute values in the range A2:A15:
The following screenshot shows how to use this formula in practice:
From the output we can see that the sum of the absolute values in the range A2:A15 is 64.
We can confirm this is correct by manually calculating the sum of each absolute value in the range:
Sum of Absolute Values = 4 + 3 + 10 + 1 + 9 + 2 + 3 + 4 + 6 + 7 + 2 + 4 + 4 + 5 = 64.
This matches the value calculated by our formula.
How the Formula Works
The ABS() function in Excel calculates the absolute value of a given number.
- For example, the absolute value of -3 is 3.
The SUM() function in Excel calculates the sum of a range of numbers.
By using the formula SUM(ABS(A2:A15)) we first convert each value in the range A2:A15 to a positive number, then we calculate the sum of all of the positive numbers.
The following tutorials explain how to perform other common operations in Excel:
How to Sum Filtered Rows in Excel
How to Select Every Nth Row in Excel
How to Count Rows with Value in Excel