Excel handles this type of thing very well (almost inherently). I believe when you know how excel handles cell references this will answer your question.
Excel cell references can be of two types, "Absolute" or "Relative"> Relative cell references are the "normal" cell references you see like A1+B1 or C1/D6, etc. All relative means to the user is that if you copy the cell to another location, the reference will update itself relative to its new position. An example would be that cell A1 has the value B1+C1 and you copy and paste cell A1 to cell A2. The value of cell A2 after the paste will not show B1+C1, rather it will update itself to show B2+C2. Notice how the positions of the reference stay the same relative to the cell that contains the formula.
An "Absolute" reference would be any reference that when you copy it does NOT update itself. You can "freeze" a row or a column within a reference by placing a dollar sign in front of it. So if, as in the previous example, you copy cell A1 to Cell A2, but you had B$1+C1 then the new value would be B$1+C2. Notice that B$1 did not update itself. You can also freeze the columns like so: $B1+C1 or both $B$1+C1
I tell you all that to let you know that all you really need to do to solve your post is put the reference in any one cell, "Freeze" what needs frozen; then just copy/paste.