R
rob
Dont copy it to the next cell [A2] down.
copy it to row 16 instead, that way ti WILL dynmaically
refer to A16:A30.
If you have to put these results in the next cell, try a
reference column next to the calc cells with 1 in row 1 2
in row 2, etc.
Now base the cell reference in the formula on this index
number:
=AVERAGE(INDIRECT(("D"&((A1*15)-14)&":"&"D"&(A1*15))))
where D is the target column and A is the column with the
index number.
There may be a more elegant solution, but, it works!
copy it to row 16 instead, that way ti WILL dynmaically
refer to A16:A30.
If you have to put these results in the next cell, try a
reference column next to the calc cells with 1 in row 1 2
in row 2, etc.
Now base the cell reference in the formula on this index
number:
=AVERAGE(INDIRECT(("D"&((A1*15)-14)&":"&"D"&(A1*15))))
where D is the target column and A is the column with the
index number.
There may be a more elegant solution, but, it works!