Introduction
The count and sum functions are the most commonly used functions in Excel. You can count and sum numbers using multiple criteria.
SUM
To sum a range of cells, a complete column, or non-contiguous columns in Excel, use the SUM function. Combine the SUM function with other Excel functions to generate amazing SUM formulas.
Most of the time, you will use the SUM function to sum a range of cells in
Excel.
In Excel, the SUM function adds the numerical values in a range of cells. Type "=SUM" followed by the data to be summed. It is categorized under the Maths and Trigonometry function. Numbers, cell references, and ranges can all be used as input to the function.
For example,
cells A1, A2, and A3 contain 200, 400, and 600, respectively. The formula “ = SUM(A1:A3) ” adds the numbers of the cells A1 to A3. It returns 1200.
| =SUM(A1:A3) |
NOTE: The SUM formula immediately adjusts when a value is added or removed. Changes to an existing cell range are also included. In addition, the function ignores empty cells and text values.
Syntax of the SUM Excel Function
number1: The first numerical value to be added.
number2: The second numerical value to be added and so on.
The argument “number1” is required, whereas the following numbers (“number 2”, “number 3”, etc.) are optional.
The number of ways to Enter the SUM Function in Excel
1. Write Manually
Type "=SUM" followed by the inputs to manually enter the SUM function.
2. Using the “math & trig” option
- Click the “math & trig” option in the Formulas tab.
- From the drop-down menu, select the SUM option as shown below.
- Enter the SUM function arguments in the "function arguments" dialogue box.
- To get the output, click "Ok."
AutoSum
The fastest approach to add numbers in a range of cells is to use the AutoSum option. In the selected cell, it automatically enters the SUM formula.
- Select the blank cell immediately following the cell to be summed up. Select cell A4.
- Click "AutoSum" in the Home tab. Alternatively, hit the shortcut keys " Alt + = " simultaneously.
1. In the selected cell, the SUM formula appears. It displays the cell references that have been summed up.
2. Press Enter.
8+ registered 