Averaging every 24th row, and posting the result to an adjacent column

[TommyC]

I have a long list of hourly values in Column C and am interested in generating averages of blocks of 24 consecutive cells. I have searched via Google and found a couple formulas that don't quite work. I also tried to search Mr. Excel and got no hits on this task.

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.

 

[TommyC]

Sorry. Post #19 should have read:

The correct formula that achieved my desired result when applied to Cell D54 is this one:

=IF(MOD(ROW(),24)=6,AVERAGE(INDIRECT("C"&ROW()-23&":C"&ROW())),"")

The only remaining mystery is this:
When I copied the formula all the way down Column D, it erased all the horizontal lines, as well as the vertical lines bordering Column E.

I checked the sheet and believe the "fill" in the cell I started with was "no color". I'll try again.