Math
Adding a list of prices
Definition
Adding a list of prices means giving SUM the price column so every listed price is totalled.
Syntax
=SUM(number1, [number2], ...)
Arguments
| Argument | Meaning |
|---|---|
number1 |
The range of prices, such as B2:B4. |
number2, ... |
Optional extra values or ranges. This lesson uses one price column. |
Worked example
A stall lists item prices in B2:B4.
| A: Item | B: Price |
|---|---|
| Mug | 13 |
| Bowl | 8 |
| Jug | 10 |
Formula: =SUM(B2:B4)
Result: 31. 13 + 8 + 10 equals 31.
Practice
Cells B2:B4 hold 9, 11, and 7. In C2, write a formula that totals those prices.
- In C2, write a SUM formula for B2:B4.
- C2 should show the total of B2:B4.
Step 1 of 2
Enter =SUM(B2:B4) in C2.
9 + 11 + 7 is 27.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses SUM.
C2 now shows 27.
The next lesson is Averaging a column of numbers.
Related functions
SUM is the function that totals that list of prices.
Common mistake
Leaving the last price out, as in =B2+B3: 13 + 8 is 21, so the jug price 10 is missing from 31.