It's not a problem but we need to know what JAN:MAR means? Is JAN a defined
name for a group of cells like A1:A30 or is JAN the name of one cell? If the
latter you could use

=SUM(INDEX(MyRange,ROWS($A$1:A1)*3-2):INDEX(MyRange,ROWS($A$1:A1)*3))

and copy down

will sum first 3 cells, then starting with the 4th cell next 3 cells and so
on, this can of course be applied to larger ranges as well and although it
might be shorter to use OFFSET this version is non volatile whereas OFFSET
or INDIRECT are not

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Justin Hoffmann" <hoffmann@-NOSPAM-tradepartnership.com> wrote in message
news:C0890965.28E3%hoffmann@-NOSPAM-tradepartnership.com...
> 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.
>