Good Morning All,
The question I'm asking is to help me out with an analyses on some statistics I have on my hobby, football.
I have a table that contains a teams playing formation e.g. 4-4-2, the score between the teams e.g. 2-0, whether the score resulted in a Win (W), Draw (D) or Loss (L) and I'm looking to count the number of Wins, Draws and Losses by the formation that they played.
I am using Excel 2007 and have attached a sample spreadsheet with comment boxes to describe my objectives.
Thank you in anticipation of your assistance.
Regards,
Colin
Bookmarks