| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help Please: Need an Average for 16 Weeks according to Month
Vendor Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7
Jun 8 Jun 15 Jun 22 Jun 29 Jul 6 Jul 13 Jul 20 Manhattan 346 349 351 348 340 333 328 El Paso 518 549 558 584 596 607 616 Terra H 478 484 470 485 470 506 491 Above is a sampling of my data. I am in desparate need of a calc that will give me the average for each Vendor by Month according to the month that is associated to Week. (there are actually 16 weeks). Every week my dates will change. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
| Sequence of Weeks in a month | Excel Worksheet Functions | |||
| Sum data for weeks in a month | Excel Discussion (Misc queries) | |||
| How do I count the number of even weeks in the current month. | Excel Worksheet Functions | |||
| Archiving 4 weeks of data into Month folders | Excel Discussion (Misc queries) | |||
Threaded Mode
