Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum months into quarters?
I have a P&L by month on a "Monthly" tab. It has the last 3 years or 36
months of data. I need to create a "Quarterly" tab where I sum the months into quarters. So my monthly tab has data in column A through AJ. I need the first Quarterly column to sum columns A:C from the Monthly. Then I want the second column to sum columns D:F from the Monthly. The problem is that if I drag the formulas like normal the second Quarterly column will add B:D from the Monthly since it is looking relative. Is there a way to tell it how many columns to skip when copying the formulas over? This could even apply to summing monthly data into annual data. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum months into quarters?
Is there any special way to do it formula-wise?
"Gary Brown" wrote: copy the formulas over 3 columns then delete the middle 2 columns. For example, copy the fomulas in Col A to Col D then delete Col's B and C. -- HTH, Gary Brown If this post was helpful to you, please select ''''''''''''''''YES'''''''''''''''' at the bottom of the post. "Steve" wrote: I have a P&L by month on a "Monthly" tab. It has the last 3 years or 36 months of data. I need to create a "Quarterly" tab where I sum the months into quarters. So my monthly tab has data in column A through AJ. I need the first Quarterly column to sum columns A:C from the Monthly. Then I want the second column to sum columns D:F from the Monthly. The problem is that if I drag the formulas like normal the second Quarterly column will add B:D from the Monthly since it is looking relative. Is there a way to tell it how many columns to skip when copying the formulas over? This could even apply to summing monthly data into annual data. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum months into quarters?
Hello,
You could adjust the formulas manually to compensate. Have you tried the Consolidation feature? Or "Group and outline" on your columns? HTH, JP On Oct 19, 5:46 pm, Steve wrote: Is there any special way to do it formula-wise? "Gary Brown" wrote: copy the formulas over 3 columns then delete the middle 2 columns. For example, copy the fomulas in Col A to Col D then delete Col's B and C. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum of Quarters | New Users to Excel | |||
End of the 4 quarters | Excel Discussion (Misc queries) | |||
Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
Formating Fiscal Quarters, rather than Months | Excel Discussion (Misc queries) | |||
How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) |