Suppose you have a journal in which you register daily sales, and you want to know the accumulated sales each day.
We can do this in Excel as follows:
Column A: Date entry.
Column B: Sales entry.
Column C: A formula to calculate the running total
- In C2 enter the same value as B2. This is the first row of sales.
- In C3 enter the formula : =C2+B3.
- Select cell C3 and drag the fill handle down until the end of your data.
- Now C4 will have the formula C3+B4, C5 will be C4+B5 and so on. The running total will be updated automatically.