formula (array or otherwise) to average data in one column in different size blocks

And oes the latest file contain anything that is related to your query. i cannot see blocks of numbers anywhere. Please take a good look at your sheet and remember that we are NOT familiar with your data. Make it clear what you want done.