Netball League Table Generator in Excel

I recently helped a reader out by creating a netball league table generator in Excel.

She wanted to be able to enter the results onto a sheet and have the league table automatically update to rank teams appropriately.

The spreadsheet allows 5 points for a win and 3 for a draw. 1 point is earned if the losing team scores half the points of the winning team. It also provides the ability deduct penalty points from a team.

Add a Running Total Column to your Spreadsheet

A running total column can be added to a spreadsheet to maintain a cumulative total for a series of values. This could be used to track a list of inventory, or a list of account transactions.

In the example below I want to add a running total of column B into column C.