Copying formula to sum multiple columns
 

I have a monthly cashflow with the data for each month in a separate columns.
To the right of the monthly data I would like to sum teh date to show a
quarterly cashflow. For the first quarter my formula is sum(b2:d2). In the
next column for the second quarter the formula should be sum(e2:g2). My
problem is that if I simply copy the formula created for Q1 it reflects
(c2:e2).

This is actually a five year cashflow so I'd really like to be able to copy
formulas to save time.

Any help would be greatly appreciated.

Copying formula to sum multiple columns
 

Try this:

Assume the first cell you enter the formula in is BA2:

=SUM(OFFSET($B2,,(COLUMNS($BA2:BA2)-1)*3,,3))

Copy across as needed.

--
Biff
Microsoft Excel MVP


"Kathy" wrote in message
...
I have a monthly cashflow with the data for each month in a separate
columns.
To the right of the monthly data I would like to sum teh date to show a
quarterly cashflow. For the first quarter my formula is sum(b2:d2). In
the
next column for the second quarter the formula should be sum(e2:g2). My
problem is that if I simply copy the formula created for Q1 it reflects
(c2:e2).

This is actually a five year cashflow so I'd really like to be able to
copy
formulas to save time.

Any help would be greatly appreciated.

Copying formula to sum multiple columns
 

Thanks Biff. It worked like a charm!

Kathy

"T. Valko" wrote:

Try this:

Assume the first cell you enter the formula in is BA2:

=SUM(OFFSET($B2,,(COLUMNS($BA2:BA2)-1)*3,,3))

Copy across as needed.

--
Biff
Microsoft Excel MVP


"Kathy" wrote in message
...
I have a monthly cashflow with the data for each month in a separate
columns.
To the right of the monthly data I would like to sum teh date to show a
quarterly cashflow. For the first quarter my formula is sum(b2:d2). In
the
next column for the second quarter the formula should be sum(e2:g2). My
problem is that if I simply copy the formula created for Q1 it reflects
(c2:e2).

This is actually a five year cashflow so I'd really like to be able to
copy
formulas to save time.

Any help would be greatly appreciated.

Copying formula to sum multiple columns
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Kathy" wrote in message
...
Thanks Biff. It worked like a charm!

Kathy

"T. Valko" wrote:

Try this:

Assume the first cell you enter the formula in is BA2:

=SUM(OFFSET($B2,,(COLUMNS($BA2:BA2)-1)*3,,3))

Copy across as needed.

--
Biff
Microsoft Excel MVP


"Kathy" wrote in message
...
I have a monthly cashflow with the data for each month in a separate
columns.
To the right of the monthly data I would like to sum teh date to show a
quarterly cashflow. For the first quarter my formula is sum(b2:d2).
In
the
next column for the second quarter the formula should be sum(e2:g2).
My
problem is that if I simply copy the formula created for Q1 it reflects
(c2:e2).

This is actually a five year cashflow so I'd really like to be able to
copy
formulas to save time.

Any help would be greatly appreciated.