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

OK AliGW,

Not too sure if that helps unless I try to explain all the fotrmulae. But here goes (I am new to the forum so hope there is an attachment. External data is pasted into P1 and the spreadsheet automatically calculates the results so that the answers appear in column B

Chris