Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding a formula around a cell reference | Excel Discussion (Misc queries) | |||
adding cell reference on a header | Excel Worksheet Functions | |||
Adding number to a cell reference not to the contents | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions |