How to use input cell value to moving average/standard error

[AdiVohra]

I have a excel spreadsheet that has a currency rate for a certain period of time. I have taken the 5 day moving average/standard error of the mean using an input cell. Whatever the cell B1 value is, the mean should identify this and take the corresponding values from the spot rate to change the moving average range. For example, in the current spreadsheet, the input value is 5 so it has taken the 5 day moving average, but if I were to change this to 10, then it should identify this and take a 10 day moving average for the spot rates. Any ideas of how to do this?

 

[uzaname]

Have a look at the INDIRECT() worksheet function. Some others than may also be needed or useful include OFFSET(), ADDRESS(), ROW() and COLUMN().

 

[AhoyNC]

Maybe something like this:
The count part of the formula just checks to see if there are enough values to average.

Excel Workbook
	A	B	C
1	Data	5	Moving Avg.
2	2		6
3	4		8
4	6		10
5	8		12
6	10		14
7	12		16
8	14		18
9	16		20
10	18		22
11	20		24
12	22		26
13	24		28
14	26		30
15	28		32
16	30		34
17	32		Not Enough Values
18	34
19	36
20	38
Sheet3