Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quantities per week??
Hi everyone, I have a table that has 4 columns on it. The first column is the product #, the 2nd column is the Date, the 3rd column is the Quantity and the 4th column is the measuring unit. Each product # has many entries in any date in the table. For example Product A on Date 01/01/2008 has the following quantities 10 in one filed, 13, in another field, 20 in another filed, etc. I need to calculate the total Quantities for each product per week. for Example week of 01/01/2008 (week)1 sold total of 43. Can any one help on this. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quantities per week??
Pivot table ?
Tim "Mike Krugler" wrote in message ... Hi everyone, I have a table that has 4 columns on it. The first column is the product #, the 2nd column is the Date, the 3rd column is the Quantity and the 4th column is the measuring unit. Each product # has many entries in any date in the table. For example Product A on Date 01/01/2008 has the following quantities 10 in one filed, 13, in another field, 20 in another filed, etc. I need to calculate the total Quantities for each product per week. for Example week of 01/01/2008 (week)1 sold total of 43. Can any one help on this. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |