We can **round a value** or can **round the output of formula** in Excel. So of course we can round a formula with the **SUM **function too. There are several ways to do it but we’ll show the 4 best methods to round a formula with the **SUM **function in Excel with sharp steps and clear illustration.

**Table of Contents**hide

**Download Practice Workbook**

You can download the free Excel workbook from here and practice on your own.

**4 Ways to Round a Formula with SUM in Excel**

To demonstrate the methods, we’ll use the following dataset that represents some product prices.

**1. Using ROUND and SUM Functions to Round a Formula in Excel**

First, we’ll do it using the **ROUND **and **SUM **functions. We can apply them in two different ways- sum the values and then round them or round the values first and then find the sum. Both ways will give you approximately the same output.

**1.1. Sum Values Then Round**

First, we’ll learn how to sum the values and then **how to round**. So, we’ll have to use the **SUM **function first and then the **ROUND **function.

**Steps:**

- Activate
**Cell C11**by clicking it. - Then type the following formula in it-

`=ROUND(SUM(C5:C9),1)`

- Finally, just press the
**ENTER**button to get the output.

**Read More:** **How to Round Excel Data to Make Summations Correct (7 Easy Methods)**

**1.2. Round Values Then Sum**

Now, we’ll round the values first and then will sum them. For that, we’ll have to use the **ROUND **function first and then the **SUM **function.

**Steps:**

- In
**Cell C11**, write the following formula-

`=SUM(ROUND(C5:C9,1))`

- Later, just hit the
**ENTER**button to get the result.

And have a look we got the same result as the previous section.

**Read More:** **Round off Formula in Excel Invoice (9 Quick Methods)**

**2. Applying Excel ROUNDUP and SUM Functions to Round a Formula**

Excel **ROUNDUP **function can be used too to round a formula with the **SUM **function. Because the **ROUNDUP **function works pretty similar to the **ROUND **function, just round the value to its nearest upper value. First, we’ll sum the values and then will apply the **ROUNDUP **function.

**Steps:**

- Write the following formula in
**Cell C11**–

`=ROUNDUP(SUM(C5:C9),1)`

- Then to get the output, just hit the
**ENTER button**.

**Read More: ****How to Round Down to Nearest Whole Number in Excel (4 Methods)**

**Similar Readings**

**How to Round to Nearest 10 Cents in Excel (4 Suitable Methods)****Rounding Time in Excel to Nearest Hour (6 Easy Methods)****How to Stop Excel from Rounding Large Numbers (3 Easy Methods)****Rounding to Nearest Dollar in Excel (6 Easy Ways)**

**3. Using ROUNDDOWN and SUM Functions to Round a Formula**

Here, we’ll apply the **ROUNDDOWN **and **SUM **functions. The **ROUNDDOWN **function works inversely to the **ROUNDUP **function, it rounds a value to its nearest lower value.

**Steps:**

- Type the following formula in
**Cell C11**–

`=ROUNDDOWN(SUM(C5:C9),1)`

- Finally, press the
**ENTER button**.

Have a look, the output is slightly different from the previous outputs because of using the **ROUNDDOWN **function but that is not so significant for a large value.

**Read More: ****How to Round Percentages in Excel (4 Simple Methods)**

**4. Manually Sum Values Then Round**

In our last method, we’ll sum the values manually instead of using the **SUM **function and then will round the output using the **ROUND **function.

**Steps:**

- First, type the following formula in
**Cell C11**to sum the values manually-

`=C5+C6+C7+C8+C9`

- Next, press the
**ENTER button**.

- Now to round the output, write the following formula in
**Cell C12**–

`=ROUND(C11,1)`

- Hit the
**ENTER**button to finish.

**Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)**

**Conclusion**

We hope the procedures described above will be good enough to round a formula with the **SUM **function in Excel. Feel free to ask any question in the comment section and please give us feedback. Visit ExcelDemy to explore more.