| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif to aggregate month to quarter
I have some monthly data in one sheet which I wish to transfer and aggregate
to another sheet at a quarterly level. I couldn't figure out if sumif function would work here, or is any other methods? E.g. sheet 1 contains (and continue for many years): Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01 sheet 2 contains (and continue for many years): 1Q01 2Q01 3Q01 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Populate year, month and quarter from entered date | Excel Discussion (Misc queries) | |||
| How can I set month/quarter/annual date intervals | Charts and Charting in Excel | |||
| Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Threaded Mode
