I have a spreadsheet I use for keep records of scores from Cricket matches (a game most of you won’t know but hopefully you’ll still be able to understand me!)
I have series of between two and six matches on separate worksheets in a workbook. I want an additional worksheet for a statistical summary of the series e.g. counting how many times each player played in the series etc. Basically I want to count and sum figures for individual players across various worksheets and summarise them separately. Can anyone offer advice as to how best to go about this?
Thanks in advance…
I have series of between two and six matches on separate worksheets in a workbook. I want an additional worksheet for a statistical summary of the series e.g. counting how many times each player played in the series etc. Basically I want to count and sum figures for individual players across various worksheets and summarise them separately. Can anyone offer advice as to how best to go about this?
Thanks in advance…
