Average a part of a on going column
 

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

Average a part of a on going column
 

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

"Capt Bill" wrote in message
...
I need to average only the last 30 entrys in a column of data
automatically.
Any suggestion will be appreciated.