| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I subtotal my weekly totals by months?
I have a plot of 5 item types going down the left side and then the values
plotted to the right with the corresponding week dates above each. I want to take that data and subtotal by months or put it into Access to subtotal by month. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I subtotal my weekly totals by months?
here is an example
SUMPRODUCT((MONTH(B4:D4)=6)*(B5:D5)) where the dates are in B4:D4, and the data to be subtotalled in B5:D5 the above sums for the month of June ( month 6) "steph44haf" wrote: I have a plot of 5 item types going down the left side and then the values plotted to the right with the corresponding week dates above each. I want to take that data and subtotal by months or put it into Access to subtotal by month. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekly Subtotal in Excel | Excel Worksheet Functions | |||
| Collecting weekly and monthly totals from daily data | Excel Worksheet Functions | |||
| How can I calculate weekly totals of daily data in Excel | Excel Worksheet Functions | |||
| Graphing past months (totals) and current month (weekly total) in | Charts and Charting in Excel | |||
| Weekly data allocated to months | Excel Worksheet Functions | |||
Linear Mode
