# How to Round a Formula with SUM in Excel (4 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

## How to Round a Formula with SUM in Excel: 4 Ways

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.

#### 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

### 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 Roundup a Formula Result in Excel

### 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. 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.

## 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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Sourov Hossain Mithun

Hello! I am Md. Sourov Hossain Mithun. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is an amazing software to learn or work. Here, I will post Excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF