sum monthly to get quarterly figures
 

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

sum monthly to get quarterly figures
 

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

sum monthly to get quarterly figures
 

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