Finding the total averages per club

[DesFellows]

Hi Everyone,

I am really struggling to find a way that I can calulate an average of averages but for only specefic sections of criteria. I also want to make it so that I can have another chart on the side that can allow me to show my most recent averages for each of the clubs. Hopefully this makes sense and any help is greatly appreciated.

Thanks,
Des

Golf .xlsx
	A	B	C	D	E	F	G	H	I	J
1	Date	Club	Carry 1	Carry 2	Carry 3	Avg			Current Averages
2	5/26/22	GW	98	105	105	103			GW
3	5/26/22	PW	113	113	112	113			PW
4	5/26/22	9	136	126	139	134			9
5	5/26/22	8	167	148	162	159			8
6	5/26/22	7	163	171	150	161			7
7	5/26/22	6	180	175	189	181			6
8	5/26/22	5	179	186	186	184			5
9	5/26/22	4H	206	207	202	205			4H
10	5/26/22	3H	200	206	216	207			3H
11	5/26/22	5W	1	223	217	147			5W
12	5/26/22	D	0	0	0	0			D
13	5/27/22	GW	102	105	105	104
14	5/27/22	PW	113	120	112	115
15	5/27/22	9	136	130	139	135
16	5/27/22	8	167	156	162	162
17	5/27/22	7	163	171	171	168
18	5/27/22	6	180	172	189	180
19	5/27/22	5	179	190	186	185
20	5/27/22	4H	206	207	207	207
21	5/27/22	3H	200	210	216	209
22	5/27/22	5W	220	223	217	220
23	5/27/22	D	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
F2:F23	F2	=AVERAGE(C2:E2)

 

[Gerald Higgins]

Hi, welcome to the board.
I've read your post a couple of times, and it makes no sense to me I'm afraid.
What exactly do you want the results to be, for the data you posted ?

 

[DesFellows]

Hi, welcome to the board.
I've read your post a couple of times, and it makes no sense to me I'm afraid.
What exactly do you want the results to be, for the data you posted ?

Hi thank you for getting back to me, Over time I will be inputting 3 shot distances that I am taking the average for as seen above. On the far right, I have another table, that I would to create a formula that takes all of the GW averages that have already been collected and then do another average. Again not sure if that makes sense, but thank you for reviewing it anyway.

 

[bosco_yip]

1] Put header name "Result" in J1

2] In J2, enter formula and copied down until blank :

=IF(I2="","",AVERAGEIF(B:B,I2,F:F))

Regards