A tally or a running total can be carried out on data in Excel with a range of formulas, but it is really easy to do the same thing simply, with a pivot table. Let’s use an example with some random sales data. If you are wondering what is a pivot table- you might want to start here.