Excel + Google Sheets · Running total
Running totals with one $
Lock the start with $ and let the end move as you drag down.
The formula
=SUM($B$2:B2)What each part means
$B$2Fixed startB2End that moves down
Example
| A | B | C | |
|---|---|---|---|
| 1 | Day | Sales | Total so far |
| 2 | Mon | 100 | |
| 3 | Tue | 150 | |
| 4 | Wed | 50 | |
| 5 | Thu | 200 |
| A | B | C | |
|---|---|---|---|
| 1 | Day | Sales | Total so far |
| 2 | Mon | 100 | 100 |
| 3 | Tue | 150 | 250 |
| 4 | Wed | 50 | 300 |
| 5 | Thu | 200 | 500 |
Step by step
- Click cell C2.
- Type the formula:
=SUM($B$2:B2) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English Running total
- Español Acumulado
- Português Acumulado