increment all cell references in an array formula by 24 when copied down a row

Hi
I have a sheet with hourly re4ading and an array formula that conditionally averages the readings to give a daily average.
I'm trying to copy this array formula dow by 24 for each cell refernce in the array so i can get the daily average for the next 24 hrs
=AVERAGE((IF($B16:$B39>$M$4,IF($I16:$I39<1,$F16:$F39))),0)
would become
=AVERAGE((IF($B40:$B63>$M$4,IF($I40:$I63<1,$F40:$F63))),0)

I've tried using offset but can't seem to get it right
.
I've got to get the daily avarages for 5 years worth of hourly averages so don't want to change each array by hand.
any help greatly appreciated

Hi and thanks for the reply. I tried this but got a value error. I'll have another go at this but I've achieved the end result by using a macro to copy the array into a new cell, copy that onto itself 24 times then copy the result back to the next cell down. I put this into a loop
Set h1 = Range("k43872")
Set h2 = Range("k43873")
Dim counter As Integer
Dim counter2 As Integer

For counter2 = 1 To 1828

Set R = ActiveCell
h1.FormulaArray = R.FormulaArray
For counter = 1 To 24
h1.Copy h2
h1.FormulaArray = h2.FormulaArray

Next counter

R = Selection.Offset(1, 0).Select
ActiveCell.FormulaArray = h2.FormulaArray
Next counter2

End Sub


crude but it works

sorry, I didn't know how. I clicked on the first reply as solved. hope this is ok.
thanks for the help.

got it and have done so, apologies for rushing in where lesser fools fear to thread