LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
PH
 
Posts: n/a
Default How to drag and autofill a non consecutive range of cells?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling cells (autofil?) in Excel 2003 Hnelg Excel Discussion (Misc queries) 3 July 5th 05 02:47 PM
More- AutoFill with Non-Seqeuntial Cell References ? [email protected] Excel Worksheet Functions 4 June 23rd 05 02:42 AM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM


All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"