Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Monthly figures to Quarters
I have many years of data in simple monthly columns. I would like to look
at the same data in calendar quaters vs. months. i.e. the sum of Jan to Mar, April to Jun, etc. and have it repeat for the entire column. Can I establish a fomula that takes the sum of 3 rows of data in the column ( Jan+Feb+Mar) then adds the next 3 rows( Apl+May+Jun) without including the previous quarters numbers. Thanks in advance for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Monthly figures to Quarters
Jake,
Assuming the months are dates, use a pivot table and group the dates by clicking year and quarters. The link below will help you with grouping pivot tables http://www.contextures.com/xlPivot07.html Don "Jake" wrote in message ... I have many years of data in simple monthly columns. I would like to look at the same data in calendar quaters vs. months. i.e. the sum of Jan to Mar, April to Jun, etc. and have it repeat for the entire column. Can I establish a fomula that takes the sum of 3 rows of data in the column ( Jan+Feb+Mar) then adds the next 3 rows( Apl+May+Jun) without including the previous quarters numbers. Thanks in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a YTD figures from changing monthly figure. | Excel Discussion (Misc queries) | |||
converting number to figures in words | Excel Discussion (Misc queries) | |||
converting figures to amount | Charts and Charting in Excel | |||
Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
Converting time figures into 24-hour format & sorting them... | Excel Worksheet Functions |