The only thing I can add is a couple of shortcuts. For instance, like Amazinz said, you can lock row, column, or both. So you could do the formula in the first cell, lock the row, and then copy that formula across as many columns as you want. Then you can copy it down and it will be how you want it.
Also, the easiest way to lock the reference is to click on the particular cell you want to lock and press F4 until you've got it like you want it (row, column, or specific cell).
And lastly, if you've got a list (say of players) on the left side of what you're doing, you can highlight the row of cells you want copied all the way down, go to the lower right-hand corner, and double click on that and it will copy as far down as your list (of players) goes. Hope that helps.