can I set up a column B that will give me the average of last 10 entries in column A. Give formula.
G gunther Dec 29, 2004 #1 can I set up a column B that will give me the average of last 10 entries in column A. Give formula.
B Bob Phillips Dec 29, 2004 #3 =AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10)) -- HTH RP (remove nothere from the email address if mailing direct)
=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10)) -- HTH RP (remove nothere from the email address if mailing direct)
L Lorence Jan 3, 2005 #4 =AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10)) Click to expand... 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
=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-10)) Click to expand... 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
