The pattern I'd like is to average, say, C31:C54 and place the result in Cell D54.

Then average C55:C78 and place the result in Cell D78, and so forth.

The examples I've seen placed all the averages in consecutive rows within an adjacent column, but I think I'd like to have them spread out in association with the 24-row blocks they represent. I hope that makes sense.

Any help is appreciated.