Excel Study · Module 4: Counting & summing with conditions
Class 36Running total
Intermediate1:38 videoFree
A running total shows how much you have made so far, after each day. In C2: =SUM($B$2:B2). F4 locks the start at B2, the end stays free, so when you fill it down every row adds from the first day to its own day.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, daily sales are in B2 to B8. Write a formula for D2 that I can fill down to D8 to show a running total: the sales so far, day by day.
The answer that works
✓ checked in Excel=SUM($B$2:B2)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.