| 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. |
| 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 | |||
Threaded Mode
