Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In column D, I have a data point every fifteen minutes for every day of the
month. In column A, I have the date and time. I would like to sum the data in Column D for each day of the month. I would like to end up with two columns- one with the date (feb 1-28) and the other with the total for each day. There are 96 data points every day- how can I do a simple drag and fill next to the column of 1-28 that gives me the total for each day? If I put in the following formula, =Sum(D1:D95), that gives me the total for Feb 1st. If I put in the next row down, =sum(D97:D191), that gives me the total for Feb 2nd. Is there some way to add 96 to the previous range so I can just drag down and fill the total column for each day? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Filling cells (autofil?) in Excel 2003 | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |