Hello,

In a lot of my work, I take monthly data and compress it into quarterly data
for reports. I use the Sum function to do this and I am looking for an easy
way to replicate the formula.

Here's my problem: Say I have data in a column covering January through
December. Elsewhere, I have a formula to calculate the First Quarter
results SUM(JAN:MAR). But when I copy this formula, I usually end up with
something like this in the subsequent cells:

SUM(FEB:APR)
SUM(MAR:MAY)
SUM(APR:JUN)
And so forth.

I realize that this is because of the position of the formulas in relation
to the original data on the spreadsheet. I could simply copy and paste the
formula every three spaces down, but I don't want to have unused space
between my quarterly formulas.

Is there something I can do to the original formula so that when I copy it,
it knows to move down three cells, rather than one? I.e., so I can copy it
many times and get this:

SUM(JAN:MAR)
SUM(APR:JUN)
SUM(JUL:SEP)
SUM(OCT:DEC)
SUM(JAN:MAR)
And so forth . . . .


Thanks for your help.