Weekly, Monthly Sums
 

Column A records a date in the format of mm/dd/yy and another column recods an amount for that particular date. I'd like to have columns that could would keep weekly, monthly, and yearly amounts. Note that not every day must have an entry. What would be the easiest way to implement this? Thanks for the help.

Weekly, Monthly Sums
 

=sumif(A:A,"=01/01/04",B:B)-Sumif(A:A,"01/31/04",B:B)

so sum everything form the start date and later, then subtract everthing
after the end date.

--
Regards,
Tom Ogilvy

"Grover" wrote in message
...
Column A records a date in the format of mm/dd/yy and another column
recods an amount for that particular date. I'd like to have columns that
could would keep weekly, monthly, and yearly amounts. Note that not every
day must have an entry. What would be the easiest way to implement this?
Thanks for the help.

Weekly, Monthly Sums
 

-----Original Message-----
Column A records a date in the format of mm/dd/yy and
another column recods an amount for that particular date.
I'd like to have columns that could would keep weekly,
monthly, and yearly amounts. Note that not every day must
have an entry. What would be the easiest way to implement
this? Thanks for the help.
.
I would approach it this way. set up columns using the
month and year functions to id the month and year of each
date. set up another column to id the week of the date
(relative to some start date) via something like

=ROUNDDOWN((A5-$A$4)/7,0)

where $a$4 contains a reference date, and a5 contains the
date in question.

Since you now have columns with the week, month, and year
of each entry you can easily do a sumif to find the
various subtotals.