BeginnerFormulas
Calculate line totals with multiplication
Multiply quantity by unit price to get a line total.
3 min10 points
Build a running total that fills down
The situation
Harbor Supply's cash forecast needs a cumulative sales column — each row showing everything up to and including that month. Written as a fixed range it is wrong on every row but the first, and written with no anchor at all it never accumulates.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Month | Sales | Running total | ||
| 2 | July | $4,200 | |||
| 3 | August | $3,800 | |||
| 4 | September | $5,100 | |||
| 5 | October | $4,600 | |||
| 6 | November | $6,200 | |||
| 7 | December | $3,900 | |||
| 8 |
Functions in this exercise
- SUM — Adds up the numbers in a range.
Who this is for
Recommended next
Related exercises
- AdvancedLookup & Reference
Lock ranges so a lookup survives fill-down
Use absolute references so a lookup does not break when copied down a column.
XLOOKUP
12 min40 points - AdvancedData Analysis
Fill a two-way summary with SUMIFS
Write one formula that stays correct filled both across and down a grid.
SUMIFS
14 min40 points - BeginnerMath Functions
Total a month of sales with SUM
Add up a column of daily sales figures to get the monthly total.
SUM
3 min10 points