Filling a formula that uses consecutive ranges of a column

[not_a_pro]

So I have all this rainfall data by the hour in one sheet, and I want to sum it up by day onto another sheet.

Is there a way for me to put the sum formula into a cell, referencing and summing the 24 individual cells from the other sheet, then just fill the formula down to each consecutive row ("day") and have each row after reference the next series of 24 cells in the first sheet?

I hope this question makes sense...

 

[cyrilbrd]

Hi, do you wish to sum for a specific time period? Is the first Column (days) entered as a date?

 

[not_a_pro]

It has a date and time in military time in column A and the values per hour in column B. So like "10/15/2014 12:00:00" in row 1, "10/15/2014 13:00:00" in row 2, etc...

 

[cyrilbrd]

..."10/15/2014 12:00:00" in row 1, "10/15/2014 13:00:00" in row 2, etc...

And you want to sum one whole day? Or a specific range?

 

[not_a_pro]

I want to sum each day into separate consecutive cells. So on a different worksheet I want to be turning the hourly data into daily totals.

It's just that I have like 6 months worth of hourly data, so I want a way to run it faster than doing every individual day and choosing the cell range, etc.

 

[not_a_pro]

I've figured it out! thanks though!!