ah you qanted yo oognore blanks not zero try this instead

=AVERAGE(INDEX(A1:A1000,LARGE(ROW(A1:A1000)*(A1:A1 000<""),7)):A1000)


Mike

"Mike H" wrote:

Hi,

Try this. Ensure the 1000 is large enought to catch all of your number range

=AVERAGE(INDEX(A1:A1000,LARGE(ROW(A1:A1000)*(A1:A1 000<0),7)):A1000)

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike

"wannabe68" wrote:

I have a column of numbers, some blank, and continually adding additional
numbers to the column. What would the formula be to continually averge the
last 7 numbers entered?
Been up all night trying to figure it out. Thank you for your help.