How to SUM Absolute Values in a Range in Excel Office 365?
Tags: kutoolsexceltutorial, sumabsolutevaluesina, kutools
Published: 2020-09-19 10:38:19

---
title: How to SUM Absolute Values in a Range in Excel Office 365?
published: true
date: 2020-09-19 04:01:16 UTC
tags: KutoolsExcelTutorial,SUMAbsoluteValuesina,Kutools
canonical_url: https://geekexcel.com/how-to-sum-absolute-values-in-a-range-in-excel-office-365/
---

## SUM Absolute Values in a Range:

In this article, we will guide you to learn how to **SUM Absolute Values in a Range in Excel Office 365** using **Kutools**. Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Steps to Sum Absolute Values in a Range in Excel:

To sum absolute values in a range, do as below instructions.

- Let’s consider an example to understand it quickly.
- The range of input numbers including absolute values are shown in the below image.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-73.png)<figcaption id="caption-attachment-14244">Example data</figcaption>

- You need to **select** a **blank**  **cell** to display the result, then on the **Kutools** tab, **Choose**  **Formula**  **Helper** Option under the **Formula** section, then **choose** the **Formula**  **Helper** option from the drop-down menu.

![Choose Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-68.png)<figcaption id="caption-attachment-14245">Choose Formula Helper option</figcaption>

- It will open the **Formula**  **Helper**  **dialog**  **box**.
- In that dialog box, **select** the **Sum absolute values ** option from **Choose**  **a**  **Formula** box.
- You can **check** the **filter** box and **enter**   **sum** into the text box to filter the formula quickly.
-  In the **Number** box, click the button to **select the input range** where you want to **sum the absolute values** only.
- Then, hit the **OK** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-31.png)<figcaption id="caption-attachment-14246">Formula Helper Dialog Box</figcaption>

- Now, you can see the **result** in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-13.png)<figcaption id="caption-attachment-14247">Result</figcaption>

## Closure:

In this guide, we helped you to learn the steps to **SUM Absolute Values in a Range in Excel Office 365** using **Kutools**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [Find the Most Common or Frequently Used Value(Word or Number) in a List in Excel](https://geekexcel.com/find-the-most-common-or-frequently-used-valueword-or-number-in-a-list-in-excel/)
- [How to Hide or Unhide Named Range in Excel Office 365? – Kutools](https://geekexcel.com/how-to-hide-or-unhide-named-range-in-excel-office-365-kutools/)