Summarizing of columns for different days of month

Charles wrote:
> 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!

Subtotals. Select the area of your data, then go to Data-Subtotals

Gordon:
Thank you for the info. What I failed to mention is that I would like for
this to occur automatically. In other words I would just type a formula
(without having to select the area I want to sum up), such as the formula
would contain some kind of an IF stament assuming the row contains jan 1 2005
data and row x contains jan 5 data etc.
If you know the answer for this I would very much appreciate it.
Thank You

"Gordon" wrote:

> Charles wrote:
> > 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!
>
> Subtotals. Select the area of your data, then go to Data-Subtotals
>
>
>