How to calculate a running total in a column

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

  1. In C2 enter the same value as B2. This is the first row of sales.
  2. In C3 enter the formula : =C2+B3.
  3. Select cell C3 and drag the fill handle down until the end of your data.
  4. Now C4 will have the formula C3+B4, C5 will be C4+B5 and so on. The running total will be updated automatically.