Average a part of a on going column

C

Capt Bill

I need to average only the last 30 entrys in a column of data automatically.
Any suggestion will be appreciated.
 
B

Biff

Hi!

One way:

Assuming the numbers are in column A, A1:An. There are no empty/blank cells
within the range and there will always be at least 30 numbers to avg:

=AVERAGE(OFFSET(A1,COUNT(A:A)-1,,-30))

If there are empty/blank cells then it's a little more complicated. Also, if
there were less than 30 numbers how would you want to handle that?

Biff
 
Top