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

[Seth.Schwarzkopf]

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?

 

[Gary Brown]

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