Last Number to Average

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

yirawan - 23 Nov 2005 16:48 GMT

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

Signature

yirawan

Reply to this Message

bpeltzer - 23 Nov 2005 16:59 GMT

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

> Is it possible to average up to certain row indicated in "Last number to
> average" or C8
[quoted text clipped - 13 lines]
>
> Thanks much

Reply to this Message

Harlan Grove - 23 Nov 2005 17:50 GMT

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

Reply to this Message

yirawan - 23 Nov 2005 18:19 GMT

thanks much

Signature

yirawan

Reply to this Message