What is the formula to sum the last ten entries in a row in an Ex.

P

Pat

I am trying to calculate a running average of the last 10 items I place in a
row. Is there an easy way to do this?
 
R

Rob van Gelder

Assumes your list starts in A1 and is contained in column A without any
gaps.

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

Pat

Rob van Gelder said:
Assumes your list starts in A1 and is contained in column A without any
gaps.

=AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10))
Click to expand...
Rob, Thanks. What if I also want to include another column?
 
R

Rob van Gelder

Assuming the columns are adjacent - by using the Width argument of Offset

This averages last 10 entries of columns A and B
=AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10, 2))
 

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

Space at end of multi page list to accommodate new entries 1
calculate last 4 data points in a column (with sometimes blank rows) 7
Need help with a formula 3
Calculating an average of data between two dates 1
Average of the last x entries with conditions 3
Formula to choose from the last column of a given row 2
Help With Formula For Cell Addresses 2
Sum Of Last Two Entries in Rotating Columns 6

Top