Last Number to Average

Is it possible to average up to certain row indicated in "Last number to average" or C8

A B C
1 5
2 7
3 8
4 10
5 6
6 10
7
8 Last number (NO.) to average: 4 (i would like to average from A1 to A4)

REsult = 7.5 or (5+7+8+10)/4

Thanks much

=AVERAGE(OFFSET($A$1,0,0,A8,1)). This will start in A1 and average the
number of rows indicated in A8.

"yirawan" wrote:

>
> Is it possible to average up to certain row indicated in "Last number to
> average" or C8
>
> A B C
> 1 5
> 2 7
> 3 8
> 4 10
> 5 6
> 6 10
> 7
> 8 Last number (NO.) to average: 4 (i would like to average from
> A1 to A4)
>
> REsult = 7.5 or (5+7+8+10)/4
>
> Thanks much
>
>
> --
> yirawan
> ------------------------------------------------------------------------
> yirawan's Profile: http://www.excelforum.com/member.php...o&userid=29036
> View this thread: http://www.excelforum.com/showthread...hreadid=487681
>
>

bpeltzer wrote...
>=AVERAGE(OFFSET($A$1,0,0,A8,1)). This will start in A1 and average the
>number of rows indicated in A8.
....

Variation on this using nonvolatile functions.

=AVERAGE($A$1:INDEX($A:$A,A8))

thanks much