Skip to content

# How to Use Excel SUM Function?

Ads

SUM Function in Excel: In math, the addition of two or more numbers is called SUM operating. Everyone knows that Excel provides various built-in formulas and functions to perform mathematical operations.

In Excel, you can add individual values, cell references, or ranges as per your preference.

In this article, we will explain how to use the Sum Function in Excel. Let’s get into this article. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Definition of Sum Function

• It is one of the built-in functions in Microsoft Excel.
• The SUM function returns the sum of values that are given in the spreadsheet.
• In other words, you can quickly find the total of the selected numbers or range in the worksheet.

## Syntax

• Here, you will see the syntax of the SUM function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=SUM(Number_1,Number_2,…..,Number_255)

### Argument Explanation

• Number_1: The first number you want to add. You need to use the cell number as a reference.
• Number_255: The last number you want to add. You need to use the cell number as a reference. The number 255 is the maximum number of counts of cells.

## Practical Examples

Let’s see some practical examples to understand how the SUM function works in the Excel spreadsheet.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have entered two input numbers in cells B3 and C3, as shown in the below image.
• After that, we need to apply the above-mentioned formulas in order to get the total of the given two values in the spreadsheet.
• Next, you will need to hit the button in order to get the result.
• We have come up with another example for your better understanding. In the following image, you will see a range of input numbers, and we want to add them and get the total value in a separate cell.
• After executing the SUM function, you will get the result, as shown in the below screenshot.

## Verdict

Let’s wrap up this article by knowing the usage of the SUM function in Excel. If you have any queries, then leave them in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Explanation

In this video, you will learn how to use the SUM function in your Excel worksheet.

Read Ahead:

Tags: