Selective Averaging

[Frank West]

Hi,

I have a list of numbers:

1
2
3
4
5
6
7
8
9
10

All I want to do, in a different cell, is to be able to average the
last five numbers in this list. A new number is added every day, so
every time I make a new entry I get a new average.

I know it's simple, but I can't seem to stumble on it.

Thanks for any help.

Frank

 

[Bob Phillips]

Hi Frank,

This should do it

=AVERAGE(OFFSET(A1,COUNT(A)-5,0,5,1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)