software

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(D195), that gives me the total for
Feb 1st. If I put in the next row down, =sum(D97191), 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?Hi

You could try using Data Pivot Table - which is designed to summarise data.
Have a look here for an intro:
peltiertech.com/Excel/Pivots/pivottables.htm

Andy

quot;PHquot; gt; wrote in message
...
gt; In column D, I have a data point every fifteen minutes for every day of
gt; the
gt; month.
gt; In column A, I have the date and time.
gt; I would like to sum the data in Column D for each day of the month.
gt;
gt; I would like to end up with two columns- one with the date (feb 1-28) and
gt; the other with the total for each day. There are 96 data points every
gt; day-
gt; how can I do a simple drag and fill next to the column of 1-28 that gives
gt; me
gt; the total for each day?
gt;
gt; If I put in the following formula, =Sum(D195), that gives me the total
gt; for
gt; Feb 1st. If I put in the next row down, =sum(D97191), that gives me the
gt; total for Feb 2nd. Is there some way to add 96 to the previous range so I
gt; can
gt; just drag down and fill the total column for each day?
gt;