Calculating an Average with variable number of columns

[rwmill9716]

I have the following table which extends to 1000 rows. Starting in Row 5, I have 10 data in columns K through T. I have specified a number in Cell F1 (could be 2 to 10). Based on that specification, I want a formula for Col I that calculates the average based on the specified number of columns: here the 4 means I use columns K through N for the calculation of the average. I will always start in Column K, but the ending will vary from L to T.

Thanks for your help,

Ric

Excel 2012
	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	4
2
3
4				Avg		1	2	3	4	5	6	7	8	9	10
5				3.45	1	6.94	0.80	1.89	4.17	9.69	1.97	7.90	9.51	6.74	8.22
6				2.61	2	4.29	2.69	0.51	2.97	9.48	1.54	8.11	2.46	6.15	7.53
7				4.49	3	9.41	1.45	3.94	3.16	1.60	5.37	6.68	7.38	9.49	9.13
8
9
Sheet1

 

[Eric W]

Try this in I5:

=AVERAGE(OFFSET(K5,0,0,1,$F$1))

 

[rwmill9716]

Thanks, Eric, that works well.

 

[Eric W]

You're welcome.