Say your original data list is on Sheet1, using Column A for dates, and
Column B for numbers.

On Sheet 2, enter your starting date in A1,
And drag down to create your list of individual dates, as far as needed to
match the date range on Sheet1.

Enter this formula in B1:

=SUMIF(Sheet1!$A$1:$A$50,A1,Sheet1!$B$1:$B$50)

And drag down to copy as needed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Charles" wrote in message
...
I have an Excel spreadsheet with two columns. Column 1 contains a date e.g.
01 Jan 2005, column 2 contains a number.
The rows are organized by date. I can have variable number (rows) of days
per month ... but all days are "bunched together"
I would like to either create a new sheet where I have the days summarized,
in other words I want one row to contain 01Jan2005 with the total of column
2
another row with the total of 02jan2005 etc.
I have been trying to figure this one out. Any help would be greatly
appreciate it.
Thank You!