can I set up a column B that will give me the average of last 10 entries in
column A. Give formula.

Hi
try
=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10))

--
Regards
Frank Kabel
Frankfurt, Germany
"gunther" schrieb im Newsbeitrag
...
can I set up a column B that will give me the average of last 10 entries
in
column A. Give formula.

=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gunther" wrote in message
...
can I set up a column B that will give me the average of last 10 entries
in
column A. Give formula.

On Wed, 29 Dec 2004 18:38:29 -0000, "Bob Phillips"
wrote:

=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10))

I thought it was much simpler
Assuming A1-A10 is 1st ten in list in col A
Enter =AVERAGE(A1:A10) in B10, then drag down as far as req'd.
it will change to =AVERAGE(A2:A11) etc. as you go.

Lorence