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.

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.

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.

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.