Average based on formula result

B1 is the result of a formula which corresponds to cell A6. How do I find the average for the five number A6:A10. B1 changes based on the input of the number in column A and so the value in B1 changes and thus the five numbers needing to be average does also.

A B
1 6
3
5
7
10
2
5
3
2
5
8
5
7

How do I find the average for the five number A6:A10

=AVERAGE(A6:A10)

The rest of the question I'm not sure what you mean....

So if B1 is 8 you want to average A8:A12? If so try

=AVERAGE(OFFSET(A1,B1-1,,5))

Originally Posted by atr

B1 is the result of a formula which corresponds to cell A6. How do I find the average for the five number A6:A10. B1 changes based on the input of the number in column A and so the value in B1 changes and thus the five numbers needing to be average does also.

A B
1 6
3
5
7
10
2
5
3
2
5
8
5
7

=AVERAGE(INDIRECT("A"&B1):INDIRECT("A"&B1+4))