Excel Practice - SUM
Instruction
Calculate total sales in column B from B2 to B6.
Formula Syntax
=SUM(number1, [number2], ...)
- number1: Numeric value or numeric reference.
- [number2]: Numeric value or numeric reference.
- ...: Additional optional arguments.
What it does
Calculate total sales in column B from B2 to B6.
weekly-sales.xlsx
| A | B | |
|---|---|---|
| 1 | Item | Sales |
| 2 | Mon | 120 |
| 3 | Tue | 180 |
| 4 | Wed | 90 |
| 5 | Thu | 160 |
| 6 | Fri | 150 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use SUM with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.