To calculate the number of games played in cells D3:D22, you will need the COUNT function. The example below shows adding up the games played for Aston Villa. - See more at: http://www.computergaga.com/tips/excel_football_league_table/calculate_table_stats.html#sthash.blfJiDZ2.dpuf