Array formula
=SCAN(0,B2:B,LAMBDA(total,value,total+value))Fills the complete running-total column.
PASTE-READY RECIPE
Calculate a Running Total in Google Sheets
Keep a cumulative sum that grows as new values are added.
QUICK ANSWER
The formula and where it fits.
Keep a cumulative sum that grows as new values are added. Use =SUM($B$2:B2), then replace the sample ranges with the columns in your sheet.
The first reference is fixed while the second moves down each row.
- Put the source data under one header row.
- Paste the formula into an empty result cell.
- Change the ranges and criteria to match your sheet.
- Check the result against one row you can verify manually.
TRY ITEdit the table.
Edit the table.
Watch the result change.
| A | B | |
|---|---|---|
| 1 | Date | Amount |
| 2 | ||
| 3 | ||
| 4 | ||
| 5 |
FORMULA OUTPUT120 · 200 · 175 · 235Recalculates from the input cells above
VARIATIONS
Use the version that fits your sheet.
Restart by category
=SUMIF($A$2:A2,A2,$B$2:B2)Keeps a separate cumulative total for each category.
Ignore blank rows
=IF(B2="","",SUM($B$2:B2))Leaves unused rows empty.
COMMON ERRORS
When the result looks wrong.
The first reference moves
Add dollar signs to $B$2.
Inserted rows change the intended start
Check the fixed starting cell after restructuring the table.
QUESTIONS
Answers before you paste.
The first reference moves
Add dollar signs to $B$2.
Inserted rows change the intended start
Check the fixed starting cell after restructuring the table.
MAKE IT YOURS
Adjust this formula →Change the ranges, labels or criteria.
Send this recipe to the SheetSteps assistant and describe how your columns are arranged.