Adding to the row digit in the cell reference
 

I've got a spreadsheet that is about 450 rows x 40 columns. I have created a
simple formula that will allow me to add certain cells in a row (ex.
=B4+E4+F4+M4+AA4). I need to copy that formula fifty-one times and have the
row number increase by 9 every time (ex. =B13+E13+F13+M13+AA13 followed by
=B22+E22+F22+M22+AA22 and so on). It may be helpful to know that the data
is grouped weekly and there are week ending dates at the beginning of every
ninth row.

Sorry if this is confusing. I know there must be a way to do this, but I
have yet to discover it.

I appreciate the help,
bobby

Adding to the row digit in the cell reference
 

If this formula is copyied to a cel 9 rows below it will automatically become

If you want to avoid 52 copies, use =IF(mod(row(),9)=4,B4+E4+F4+M4+AA4,"")
and copy down the column.
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme


"bobby" wrote:

I've got a spreadsheet that is about 450 rows x 40 columns. I have created a
simple formula that will allow me to add certain cells in a row (ex.
=B4+E4+F4+M4+AA4). I need to copy that formula fifty-one times and have the
row number increase by 9 every time (ex. =B13+E13+F13+M13+AA13 followed by
=B22+E22+F22+M22+AA22 and so on). It may be helpful to know that the data
is grouped weekly and there are week ending dates at the beginning of every
ninth row.

Sorry if this is confusing. I know there must be a way to do this, but I
have yet to discover it.

I appreciate the help,
bobby

Adding to the row digit in the cell reference
 

Why can't you simply enter your first formula in say A4,
then, select A4 to A12, with A5 to A12 *empty*,
and then grab the fill handle of that 9 cell selection,
and drag down to copy as needed?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bobby" wrote in message
...
I've got a spreadsheet that is about 450 rows x 40 columns. I have
created a
simple formula that will allow me to add certain cells in a row (ex.
=B4+E4+F4+M4+AA4). I need to copy that formula fifty-one times and have
the
row number increase by 9 every time (ex. =B13+E13+F13+M13+AA13 followed by
=B22+E22+F22+M22+AA22 and so on). It may be helpful to know that the data
is grouped weekly and there are week ending dates at the beginning of
every
ninth row.

Sorry if this is confusing. I know there must be a way to do this, but I
have yet to discover it.

I appreciate the help,
bobby