close
I need to average only the last 30 entrys in a column of data automatically.
Any suggestion will be appreciated.
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
quot;Capt Billquot; gt; wrote in message
...
gt;I need to average only the last 30 entrys in a column of data
gt;automatically.
gt; Any suggestion will be appreciated.
全站熱搜
留言列表
