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