Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
SUM
One formula, and the total appears. Better still, it's live. Try changing Monday's sale.
Try this lesson free →Example
You could add five numbers in your head. Or type one formula into cell D7:
=SUM(D2:D6)| Day | Product | Qty | Revenue |
|---|---|---|---|
| Mon | Phone case | 12 | 96 |
| Tue | Charger | 8 | 120 |
| Wed | Earbuds | 5 | 175 |
| Thu | Phone case | 15 | 120 |
| Fri | Screen guard | 20 | 100 |
| Total |
Key points
=Every formula starts with an equals sign. It tells the sheet: work this out.
SUMThe function's name. SUM adds numbers together.
(D2:D6)The range, in brackets. The colon means 'through', so D2 through D6.
Put together: =SUM(D2:D6) adds everything from D2 to D6.
Practice
1. Build a formula for D7 that totals the revenue, D2 to D6.
=SUM(D2:D6)2. Build a formula for C7 that totals the quantity sold, C2 to C6.
=SUM(C2:C6)3. In D7, total the revenue for the first three days only (Monday to Wednesday).
=SUM(D2:D4)4. In C7, total the quantity sold all week.
=SUM(C2:C6)5. In D7, total the revenue for Thursday and Friday.
=SUM(D5:D6)Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →