Sum months into quarters?

S

Steve

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!
 
G

Gary Brown

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
[email protected]
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.
 
S

Steve

Is there any special way to do it formula-wise?


Gary Brown said:
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
[email protected]
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.
Click to expand...
 
J

JP

Hello,

You could adjust the formulas manually to compensate. Have you tried
the Consolidation feature? Or "Group and outline" on your columns?


HTH,
JP
 
Top