americanpie3
Board Regular
- Joined
- Jul 16, 2003
- Messages
- 187
- Office Version
- 365
Hello everyone,
I run a dart league. I have a worksheet with players on their teams. Each week I enter the stats. I have stats for averages for the season and per week.
Per week it runs perfectly fine
=IFERROR(AVERAGE($B4:$X4),0)
Here's the average for the season
=AVERAGE(Week1!B69:X69,Week2!B69:X69,Week3!B69:X69,Week4!B4:X4,Week5!B4:X4,Week6!B4:X4,Week7!B4:X4)
As you can see this person has changed teams. I want to make this sheet more dynamic because if this person changes teams again I won't have to change the formula, each week I will have to change this formula and of course all I want to do is enter numbers. Of course once the sheet if perfect, I will hand it off to someone else.
Can anyone suggest something?
Thanks
I run a dart league. I have a worksheet with players on their teams. Each week I enter the stats. I have stats for averages for the season and per week.
Per week it runs perfectly fine
=IFERROR(AVERAGE($B4:$X4),0)
Here's the average for the season
=AVERAGE(Week1!B69:X69,Week2!B69:X69,Week3!B69:X69,Week4!B4:X4,Week5!B4:X4,Week6!B4:X4,Week7!B4:X4)
As you can see this person has changed teams. I want to make this sheet more dynamic because if this person changes teams again I won't have to change the formula, each week I will have to change this formula and of course all I want to do is enter numbers. Of course once the sheet if perfect, I will hand it off to someone else.
Can anyone suggest something?
Thanks