| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing Weekly Totals into Monthly Totals
06/01/06 06/08/06 06/15/06 06/22/06 06/29/06
fish 10 12 11 14 12 meat 40 45 41 41 43 eggs 50 50 51 52 53 fruit 1 2 1 3 2 veggies 90 91 92 89 89 I need a way to summarize this weekly data into montly data. For example June Fish totals would be 59. I am going to have 3-4 yrs of weekly data that I need to show by month. I know I can chart it, but I want it in data sheet format not charts. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Template to track weekly & monthly totals, by day & date? | Excel Discussion (Misc queries) | |||
| Template track phone traffic to determine weekly, monthly trends. | New Users to Excel | |||
| Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
| Weekly and Monthly Subtotals | Excel Discussion (Misc queries) | |||
| How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
Threaded Mode
