Wow, thank you for the quick response. This works for me!

"Bob Phillips" wrote:

Hi Judy,

How about

=SUM(OFFSET(INDEX(Sheet2!$1:$1,1,(COLUMN()*3)-2),,,,3))

--
HTH

Bob Phillips

"Judy Ward" wrote in message
...
Let's say Sheet 2 has many columns of figures for many months (column A is
January, column B is February and so on).

I want a formula in Sheet 1 that sums up three months at a time. For
example, Sheet1.A1 = SUM(Sheet2:A1:C1), Sheet1.B1 = SUM(Sheet2:D1:F1).

I would just type these formulas in, but I could potentially have to do
this
for 24 quarters across (copying and pasting one forumla across doesn't
work).

Can anyone help me with this?

Thank you,
Judy