## You are learning SUM in MS Excel

How to sum absolute values in Excel (ABS function with SUM)?

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.