There are two main ways to sum the absolute values in Excel using the ABS function and the SUM function:

Method 1: Using an Array Formula

1. Select the cell where you want the sum of absolute values to appear.
2. Enter the formula `=SUM(ABS(A1:A10))` (replace A1:A10 with your actual data range).
3. Important: Instead of pressing just Enter, press `Ctrl+Shift+Enter` together. This is crucial because it enters the formula as an array formula, which is required for this calculation. You'll notice the curly braces {} appear around the formula in the formula bar, indicating it's an array formula.

Method 2: Using SUMPRODUCT

1. Select the cell where you want the sum of absolute values to appear.
2. Enter the formula `=SUMPRODUCT(ABS(A1:A10))` (replace A1:A10 with your actual data range).
3. Press Enter. SUMPRODUCT is a built-in function that automatically performs the array operation within the formula itself, so you don't need the `Ctrl+Shift+Enter` key combination.

Both methods achieve the same result: calculating the sum of the absolute values within the specified range.