Beginner Essentials
🌙 A Busy Monday at Moon & Mallow
Maya needs today’s total sales. Build the formula as you would in Excel, then press Enter to calculate it.
Try it like Excel
Click B8 and type =SUM(, then drag from B2 down to B6. Type ), then press Enter.
Or select B2:B6 and press Alt + =, then Enter.
Selected: none
Spreadsheet ready
| A | B | |
|---|---|---|
| 1 | Product | Sales |
| 2 | Nebula Latte | £46.80 |
| 3 | Lunar Mocha | £37.50 |
| 4 | Galaxy Brownie | £28.80 |
| 5 | Cosmic Tea | £19.60 |
| 6 | Moon Cookie | £23.40 |
| 7 | ||
| 8 | Total | Click here to enter a formula |
Why would I use this at work?
SUM is one of the most useful Excel functions. You can use it for sales totals, expenses, hours worked, stock quantities, budgets and much more.
Want to practise more Excel skills? Return to the Excel Practice Lab.