# 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  