Field , Date range and Sum from worksheet import
 

I import a large worksheet, I need to sum all the quantities of the "part
number"'s into sequencial weekly buckets. on a seperate report worksheet. Can
I use one formula to indicate the "part number", weekly range and sum? then
autofill for weekly totals? where the import columns are, Part#, ship date,
Qty?
the report colums are Part#, week1 totals, week2 totals, week3 totals..,