Here is the data. Below the data is what I want to do.
Date......... Amount
01/01/2009 125
01/02/2009 283
01/03/2009 632
etc.
12/31/2009 396
I want to calculate the totals for each month at the bottom of the data.
01/2009 xxx Total
02/2009 xxx Total
etc.
12/2009 xxx Total
I have tried the SUMIF function, but it either does not work or I have the wrong syntax.
=SUMIF(A1:A365,AND(">=1/1/2009","<=1/31/2009"),B1:B365)
It would be better for the criteria to be a reference to the month and year in column A instead of AND(">=1/1/2009","<=1/31/2009").
Thanks for your help and expertise.
Dean
Date......... Amount
01/01/2009 125
01/02/2009 283
01/03/2009 632
etc.
12/31/2009 396
I want to calculate the totals for each month at the bottom of the data.
01/2009 xxx Total
02/2009 xxx Total
etc.
12/2009 xxx Total
I have tried the SUMIF function, but it either does not work or I have the wrong syntax.
=SUMIF(A1:A365,AND(">=1/1/2009","<=1/31/2009"),B1:B365)
It would be better for the criteria to be a reference to the month and year in column A instead of AND(">=1/1/2009","<=1/31/2009").
Thanks for your help and expertise.
Dean