## How to sum largest or smallest 3 values in a list of Excel?

It is common for us to add up a range of numbers by using the SUM function, but sometimes, we need to sum the largest or smallest 3, 10 or n numbers in a range, this may be a complicated task. Today I introduce you some formulas to solve this problem.

**Sum the largest / smallest 3 values in a range with formulas**

**Sum absolute values in a list with Kutools for Excel**

#### Recommended Productivity Tools for Excel/Office

**Office Tab**: **Bring tabbed editing to Excel and other Office software, just like Chrome, Firefox and Safari.****30-day Unlimited Free Trial**

**Kutools for Excel**: **300 powerful features make Excel much easy and increase productivity immediately.****60-day Unlimited Free Trial**

#### **Sum the largest / smallest 3 values in a range with formulas**

Supposing you have the following range of data need to sum the largest or smallest 3 values.

Here I can talk about some formulas for you:

**1. LARGE function:**

You need the LARGE formula three times and then sums the results when you want to sum the top 3 values, do as this:

Enter this LARGE formula into a blank cell **=LARGE(A1:D10,1)+ LARGE(A1:D10,2)+ LARGE(A1:D10,3)**, see screenshot:

And then press **Enter** key, you will get the result.

**Notes:**

(1.) If you want to sum the largest 5 values, you need to use it 5 time as this: **=LARGE(A1:D10,1)+LARGE(A1:D10,2)+LARGE(A1:D10,3)+LARGE(A1:D10,4)+ LARGE(A1:D10,5)** ,you can expand this formula as you need.

(2.) Use the following SMALL function, you can get the result of the smallest 3 values: **=SMALL(A1:D10,1)+SMALL(A1:D10,2)+ SMALL(A1:D10,3)**.

**2. Array formulas:**

You can also use the following array formulas:

Enter this formula into a blank cell, **=SUM(LARGE(A1:D10,{1,2,3}))**, and then press **Ctrl + Shift + Enter** keys to get your result .

This formula will become unwieldy as n gets larger. For example, to sum the top 20 values in a range, a formula must contain a list of integers from 1 to 20. Here is a quicker and more convenient array formula: =**SUM(LARGE(A1:D10,ROW(INDIRECT ("1:20")))).**

After enter this formula, remember to press **Ctrl + Shift + Enter** keys. If you need to sum a different quantity of numbers, just change the 20 to the desired number.

**Note:** You can also add up the smallest 3 values with these array formulas as above steps:

**=SUM(SMALL(A1:D10,{1,2,3}))**

**=SUM(SMALL(A1:D10,ROW(INDIRECT ("1:3"))))**

#### ** Sum absolute values in a list with Kutools for Excel**

Maybe in some case, you have a list of values which contains positive and negative values, and you just want to sum all the absolute values of them up, and how can you quickly get it done?** Kutools for Excel**'s **Sum absolute values** function can do a favor for you.

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. |
||

After installing Kutools for Excel, please do as below:(**>Free Download Kutools for Excel Now!) **

1. Select a blank cell which will place the summed result, and click **Kutools** > **Formulas Helpers** > **Sum absolut values**. See screenshot:

2. In the **Formula Helper** dialog, click to select the list of values you want to sum their absolute value, and then click **Ok**. See screenshot:

Now it has sum up the absolute values of the list right now.

#### **Sum Absolute Value In A Range**

Sum numbers in a cell function can quickly sum up all numbers/digits in a single cell. |

**Related articles:**

** Recommended Productivity Tools**

**Office Tab**

** Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.**

**Kutools for Excel**

**Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!**

**300 New Features for Excel, Make Excel Much Easy and Powerful:**

- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...