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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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))
 
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?
 
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))
 
You must log in or register to reply here.

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

Average of the last x entries with conditions 3
Sum Of Last Two Entries in Rotating Columns 6
How to average the last 10 numbers in a row? 9
Possible sumproduct to find/sum the last entry in each row 2
Sum(indirect(Address...... 3
hidden rows problem 7
Scrabble Value calculation for Welsh words 0
What is the "--" (double dash) in MS Excel formula? 2

Back
Top