Excel: Add Negative Numbers as Positive Values in a Total
Question details
Create a total that adds negative and positive numbers as positive amounts.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to calculate the total of a range without allowing negative values to reduce the result.
- Observed behavior
- Each number in the selected range should be treated by its absolute value before the total is calculated.
Confirm that the cells contain real numeric values rather than numbers stored as text. Replace E3:E7 in the formula with the range you want to total.
Use SUM with ABS to total every value as a positive amount
Use this method in current Excel versions when you want to add the absolute value of every number in a range.
The ABS function removes the negative sign from a number without changing its magnitude. Wrapping ABS inside SUM produces a total where both -10 and 10 contribute 10.
Click the blank cell where you want the positive-value total to appear.
Type =SUM(ABS(E3:E7)), replacing E3:E7 with your own cell range.
Press Enter to total all values as positive amounts.

Use SUMPRODUCT with ABS for broad Excel compatibility
Use this alternative if your Excel version does not evaluate =SUM(ABS(range)) with a normal Enter key press.
Total Negative Values as Positive Amounts in WPS Spreadsheets
WPS Spreadsheets supports the ABS function, so you can convert negative values to positive amounts within a formula and calculate an accurate total without changing the source values.
- 1. Open the worksheet in WPS Spreadsheets: Open your Excel workbook in WPS Office and select the worksheet containing the values.
- 2. Select the result cell: Click the empty cell where you want the total to appear.
- 3. Enter the ABS total formula: Type =SUM(ABS(E3:E7)) and replace E3:E7 with your required range.
- 4. Confirm the formula: Press Enter to display the total with negative numbers counted as positive amounts.

Frequently Asked Questions
What does the ABS function do in Excel?
ABS returns a number's absolute value. For example, ABS(-25) returns 25, while ABS(25) also returns 25.
How do I add positive and negative numbers without subtracting the negative values?
Enter =SUM(ABS(E3:E7)) in the result cell, replacing E3:E7 with your range. This adds every value by its magnitude.
Why does my ABS total not calculate in an older Excel version?
Older Excel versions may require an array formula for =SUM(ABS(E3:E7)). Use =SUMPRODUCT(ABS(E3:E7)) and press Enter as a compatible alternative.
Does the ABS formula change the negative numbers in my cells?
No. ABS changes values only within the calculation result. The original cells remain negative or positive as entered.




