colum B=average of last 10 values in A

G

gunther

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

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

--

HTH

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula 2
calculate last 4 data points in a column (with sometimes blank rows) 7
Space at end of multi page list to accommodate new entries 1
Trying to find additional ranges outside of min, max, and average 2
Standar deviation across sheets help 0
Finding the weighted average of text that have been given values 1
countifs Function not giving desired result with date criteria 2
Need help with average/lookup formula 2

Top