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

  1. Select the cell where you want the result to appear.
  2. Type =SUM( followed by the range or numbers to add.
  3. 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