Prev: Macro to extract data from multiple Excel files
Next: onGetEnabled
From: Seth.Schwarzkopf on 19 Mar 2010 13:27
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?
From: Gary Brown on 19 Mar 2010 14:19
- 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?
 | 
Pages: 1
Prev: Macro to extract data from multiple Excel files
Next: onGetEnabled