Averaging Values Based on Specific Crtieria

Hi!

I have the following data. I want to have a formula that averages monthly energy usages from month i to month k based on values I enter for a month. So suppose I enter the values 5 and 10, I want a formula that can average the average monthly energy usage from month 5 to month 10. Any help? I am very new to excel, so any help would be really helpful!

Thank you!

Please Login or Register  to view this content.

Let's say your data is in columns A, B, C. Let's say i is in D1 and k is in E1. You can use this formula to average column C:

Formula:

Please Login or Register  to view this content.

Values as displayed

	A	B	C	D	E	F
1	Month	Monthly Total Load (kWh)	Average Monthly Energy Usage (kwh/month)	5	10	863.5
2	1	1053	868
3	2	922	760
4	3	982	809
5	4	900	742
6	5	934	770
7	6	990	816
8	7	1254	1034
9	8	1163	958
10	9	987	814
11	10	957	789
12	11	966	796
13	12	1060	874

Underlying formulas

	A	B	C	D	E	F
1	Month	Monthly Total Load (kWh)	Average Monthly Energy Usage (kwh/month)	5	10	=AVERAGE(INDEX($C$2:$C$13,D1):INDEX($C$2:$C$13,E1))
2	1	1053	868
3	2	922	760
4	3	982	809
5	4	900	742
6	5	934	770
7	6	990	816
8	7	1254	1034
9	8	1163	958
10	9	987	814
11	10	957	789
12	11	966	796
13	12	1060	874