americanpie3
Board Regular
- Joined
- Jul 16, 2003
- Messages
- 187
- Office Version
- 365
Hello,
As part of a dart league we calculate averages, number of closes and also compare stats week to week.
I have 1 worksheet that I put in the lineups and all their scores and finishes. Then on my summary work sheet I have the player's name, season average, last week's average, total finishes, last week finishes
I have this formula on my main sheet for looking up which works just perfectly =INDEX(Week1!Z1:Z60,MATCH(A20,Week1!A1:A60,0)) which I use to lookup last week's average
What I would love is to have is a marriage of index and match to go with this formula =IFERROR(AVERAGE(Week1!B2:X2,Week2!B2:X2),0) for the season averages. This means that the player's name and scores must be on that row.
As you can see in the 2nd formula, it does not allow my sheet to be dynamic.
I hope I've explained myself clearly enough.
Thank you all.
As part of a dart league we calculate averages, number of closes and also compare stats week to week.
I have 1 worksheet that I put in the lineups and all their scores and finishes. Then on my summary work sheet I have the player's name, season average, last week's average, total finishes, last week finishes
I have this formula on my main sheet for looking up which works just perfectly =INDEX(Week1!Z1:Z60,MATCH(A20,Week1!A1:A60,0)) which I use to lookup last week's average
What I would love is to have is a marriage of index and match to go with this formula =IFERROR(AVERAGE(Week1!B2:X2,Week2!B2:X2),0) for the season averages. This means that the player's name and scores must be on that row.
As you can see in the 2nd formula, it does not allow my sheet to be dynamic.
I hope I've explained myself clearly enough.
Thank you all.