Averaging

[Kip]

I am trying to put together a spreadsheet where I get a 26 week average on
the first 26 items in the column. When I insert a cell in the column the
formula expands to 27 items. How do I lock the formula on 26 items/

 

[Billy Liddel]

Kip

Use the indirect function. In say B1 Type the range e.g. B2:b30 and use the
following
=AVERAGE(INDIRECT(B1))