Hello:
I have a worksheet that displays costs by week in columns, as shown below. I added columns to group the week into months, the months into quarters and the quarters into financial years. How do I use the SubTotals function to get sums by month, quarter & year? I go to the Menu and choose Data/ Subtotals- but it seems it only allows me to create one subtotal not 3. Thanks !

Week Internal Costs Vendor Costs
3-May-10 $0
10-May-10 $1,500
17-May-10 $ 2,625 $1000