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.
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.