Field , Date range and Sum from worksheet import

J

Jim e boy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top