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.