Averaging

  • Thread starter Thread starter Kip
  • Start date Start date
K

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/
 
Kip

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