Averaging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kip - 21 Feb 2008 23:43 GMT

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/

Signature

Kip

Reply to this Message

Billy Liddel - 22 Feb 2008 00:59 GMT

Kip

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

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

Reply to this Message