How to make weekly totals change as the days in the week change ye
 

i have a basic table built with dates (jan 1 to jan 31) in colum A and data
in colums B to K. i want to have a weekly total break down at the bottom of
the sheet, i know the easy way to do it is sum the data in to the lower cells
but i want the weekly totals to change every year. Jan 2010, jan 2011 ect.
basicly what i am trying to do is have a Sunday through Saturday total from
the informatin stored in the colloms and rows above it. can it be done?

How to make weekly totals change as the days in the week change ye
 

- Insert a New Column 'A'
- The Dates (jan 1 to jan 31) are now in Column 'B'
- In Column 'A', put the following formula...
=WeekNum(B1)
This will give you the Week Number of the date.
If this function is not available, and returns the #NAME? error,
activate the Analysis ToolPak add-in that comes with Excel.
How:
- On the TOOLS menu, click ADD-INs
- In the ADD-INS AVAILABLE list, select the ANALYSIS TOOLPAK box then
click OK

At the bottom of the worksheet, put week numbers 1 thru 5. Use the SUMIF
function to reference the weeknumbers in column A and the amounts you wish to
sum in other columns.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Seth.Schwarzkopf" wrote:

i have a basic table built with dates (jan 1 to jan 31) in colum A and data
in colums B to K. i want to have a weekly total break down at the bottom of
the sheet, i know the easy way to do it is sum the data in to the lower cells
but i want the weekly totals to change every year. Jan 2010, jan 2011 ect.
basicly what i am trying to do is have a Sunday through Saturday total from
the informatin stored in the colloms and rows above it. can it be done?