# 5 Ways to Round a Formula with SUM Function in Excel

The **ROUND function** returns a number rounded with specific digits in Excel. You can also use the **ROUND** function with other functions that perform mathematical operations on numbers in Excel, such as the **SUM function**. There are various ways to round a formula with the **SUM** function in Excel. In this article, we’ll outline the five best methods of doing it.

## Introduction to the Dataset

Here is the dataset that I am going to use for this article. The dataset has a list of a few grocery items (**column A**) and their prices (**column B**) beside them. And, at the bottom of the data table, there is an empty cell (**B9**) for calculating the **Total Price**.

## Quickest Way to Round a Formula with SUM Function

Surely the easiest way to round a formula having the **SUM** function is to use both the **ROUND** function and **SUM** function in a single formula.

**Syntax**

=ROUND(SUM(number1,[number2],...), num_digits)

**Formula**

**=ROUND(SUM(B2:B8),2)**

**Usage Guide**

**Step_1**: Select an empty cell (**B9**).

**Step_2**: Type the formula in cell **B9**.

**Step_3**: Press **ENTER** to insert the formula.

**Formula Explanation**

**B2:B8**is the range of selected cells.**2**refers that you want to keep**2**digits after the**decimal point**.

**Final Result**

The total price of all the grocery items is **$777.0600**.

**2 Ways to Round to Nearest 50 Cents in Excel****4 Formulas to Round Off Prices To Nearest 10 Cents in Excel**

### Alternative Way #1: Using the SUM function and Round Function Separately

This technique is also easy to remember. You will have to apply the **SUM** function and the **ROUND** function separately. The only extra work for this method is adding an additional cell below the data table.

**Syntax **

**=SUM(number1,[number2],...)**

**=ROUND(number, num_digits)**

**Usage Guide**

**Step_1**: In cell **B9**, type the following formula:

**=SUM(B2:B8)**

**Step_2**: Press **ENTER**.

**Formula Explanation**

Here **B2:B8 **is my selected cell range that I want to sum up.

**Step_3**: Select another cell to apply the **ROUND** function.

**Step_4**: Now write the following formula in cell **B10**:

**=ROUND(B9,2)
**

**Step_5**: Press **ENTER** to see the result.

**Formula Explanation**

**B9**is the target value.**2**means I want to round the number to**2**decimal places.

**Final Result**

Here is the final outcome. Take a look.

### Alternative Way #2: Apply the ROUNDUP Function to Round Formula with SUM Function

In this method, I will be using a formula including both the **ROUNDUP** **function** and the **SUM** function. The **ROUNDUP** function is similar to the **ROUND** function. The only difference is **ROUNDUP** always rounds a number up.

**Syntax**

**=ROUNDUP(SUM(number1,[number2],...), num_digits)**

**Formula**

=ROUNDUP(SUM(B2:B8),1)

**Usage Guide**

**Step_1**: In cell **B9**, enter the formula.

**Step_2**: Press **ENTER**.

**Formula Explanation**

**B2:B8**is my selected cell range.**1**means I want to display**1**digit after the decimal point.

**Final Result**

Here the result is** $774.1000 **which has only one digit after the decimal.

**3 Formulas to Round Time to the Nearest Minute in Excel****5 Ways to Round Up a Formula Result in Excel**

### Alternative Way #3: Apply the ROUNDDOWN Function to Round Formula in Excel with SUM Function

The **ROUNDDOWN function** in Excel is used to round a number down to the specified number of decimal places.

**Syntax **

=ROUNDDOWN(SUM(number1,[number2],...), num_digits)

**Formula**

**=ROUNDDOWN(SUM(B2:B8),0)**

**Usage Guide**

**Step_1**: At first select cell **B9 **then write down the formula.

**Step_2**: Press the **ENTER** key.

**Formula Explanation**

**B2:B8**is the selected cell range for this formula.**0**is the required number of digits after the decimal point.

In this particular case, I input **0** in the formula because I want a whole number as an outcome.

**Final Result**

Here is the final outcome in the image below:

Alternative Way #4: Manually Sum Values and Use ROUND function

If you can not memorize the above methods, this technique is probably best for you. Technically, this method will help you to manually sum up all the values and then round up the result with a **ROUND** function.

**Syntax**

=cell(1)+cell(2)+...+cell(N)

=ROUND(number, num_digits)

**Usage Guide**

**Step_1**: Select an empty cell (**B9**).

**Step_2**: Sum up all your target cells one after one with this formula:

**=B2+B3+B4+B5+B6+B7+B8**

**Step_3**: Press **ENTER** to apply the formula.

**Step_4**: Now again select an empty cell.

I have selected cell **B10**.

**Step_5**: Type the **ROUND** formula in cell **B10**:

=ROUND(B9,2)

**Step_6**: Press the **ENTER** key.

**Formula Explanation**

**B9**holds the result of sum-up values.**0**is the required number of digits after the decimal point.

**Final Result**

This way you can use the **ROUND** function in Excel with sum to calculate your desired value.

## Conclusion

I hope now you have a complete idea about the usage of the **ROUND** function, **SUM** function, and their combined formulas. So if you find this article helpful, please do visit our **Blog** page for more Excel-related articles. And don’t forget to comment in the comment section if you have any confusion regarding this topic. Have a good day!

**Related Articles**

**How to Round Off Numbers in Excel (9 Methods)****3 Formulas for Rounding Time to the Nearest Hour in Excel****[3 Formulas] Round Off Time to Nearest Multiple of 15 Minutes in Excel****2 Ways to Stop Excel from Rounding up Percentages****How to Stop Excel from Rounding 16-Digit Numbers (2 Methods)****[3 Ways] Round Off Time to Nearest Multiple of 5 Minutes in Excel**