Weekly, Monthly Sums

G

Grover

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.
 
T

Tom Ogilvy

=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 said:
Column A records a date in the format of mm/dd/yy and another column
Click to expand...
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.
 
G

Guest

-----Original Message-----
Column A records a date in the format of mm/dd/yy and
Click to expand...
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
Click to expand...
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.
 
Top