103. Adding numbers with the SUM function
Adding Numbers with the SUM Function
The **SUM** function in Excel allows you to add a range of numbers efficiently. It is one of the most commonly used functions for calculations and works by specifying a range of cells or individual values.
Syntax of the SUM Function
=SUM(number1, [number2], ...)
- number1: The first number, cell reference, or range.
- [number2]: (Optional) Additional numbers, cell references, or ranges.
Steps to Use the SUM Function
- Select the cell where you want the result to appear.
- Type
=SUM(
followed by the range or numbers to add. - Close the parentheses
)
and press Enter to see the result.
Interactive Example: SUM Function
Item | Amount |
---|---|
Apples | 10 |
Bananas | 20 |
Oranges | 15 |
Total | Click Calculate |
Edit the amounts in the table above and click "Calculate Total" to see the SUM function in action.
This example demonstrates how the SUM function works to calculate the total of a range of numbers in Excel.
Comments
Post a Comment