Sum absolute values in Excel - A complete guide

Here are some useful formulas for you to sum the absolute values. Please look at this:

Formula 1: Use SUM and ABS functions

Please enter below formula into a cell where you want to display the result, and press "Ctrl" + "Shift" + "Enter" keys to get the sum.

=SUM(ABS(A2:A14))

Formula 2: Use SUMPRODUCT and ABS functions

This "Sumproduct" formula can also help you. Type the following formula and press the "Enter" key to get the sum of the absolute values..

=SUMPRODUCT(ABS(A2:A14))

Formula 3: Use SUMIF function

With the following two SUMIF functions, you can quickly calculate the sum of the absolute values, do as this:

1. In a blank cell which you want to put the result, enter one of below formulas, and press the "Enter" key.

=SUMIF(A2:A14,">0") - SUMIF(A2:A14,"<0")

=SUM(SUMIF(A2:A14,{">0","<0"})*{1,-1})

Apart from formulas, we can change all negative numbers to positive ones and then sum up these numbers. And you can apply the "Change Sign of Values" utility of "Kutools for Excel" to get it done with ease.

1. Select a blank cell below the numbers whose absolute values you will add, type the formula into it, and press the "Enter" key.

=SUM(A2:A14)

2. Select these number cells (A2:A14 in our case), and click "Kutools" > "Content" > "Change Sign of Values".

3. In the opening "Change Sign of Values" dialog box, please check the "Change all negative values to positive" option, and click the "Ok" button.

Now all negative values are converted to positive values, and the sum result updates automatically.