Averaging continuous "blocks" of cells

Hi,

I have a data set with 1 second intervals running up 180 seconds. I would like to be able to break this down into 15 second averages i.e. from 1 to 15, 16 to 30 etc. Please can someone show me an easy way to do this so I do not have to manually input the formula.

I have included a spreadsheet as an example.

Many thanks,

Andy

Data Averaging Spreadsheet.xlsx

Put this in E3:

=AVERAGEIFS($B$3:$B$179,$A$3:$A$179,">"&D3-15,$A$3:$A$179,"<="&D3)

then copy down.

Hope this helps.

Pete