So this is more an Excel question than a math one, right?
Are you trying to copy the formulas to another location, and that's what's not working?
Without seeing it or more information, I'd guess you're having ABSolute issues. So this may be relevant. Or it may not be. :mrgreen:
When you use absolutes, you're attempting to lock in both or one of a cell's column or row location.
So if the formula in cell D10 is =$A$1, no matter where you copy or move it to on any other cell on your spreadsheet, it will always look for the value in cell A1.
Now, if the formula was =$A1, and you copied if from cell10
to, say, cell D11, it would still be locked in to column A, but would now be looking at the value one down (since D11 is located one cell down from D10).
Same goes for =A$1. If you copied that formula from cell D10 to cell D11, it would still look at the contents of cell A1. However, if you copied it to cell E10, then it would look at the value in cell B1.
Now, you can change each formula manually. But that's not fun or efficient.
When you set the initial formulas to figure out whatever it - totals/weighted avgs/%, - look at what would remain constant from student to student - would it be the info in a column or a row? And then lock that in with a $.
When you hit F4 to make an cell ABS in your formula, it will do a double $x$1 first. Hit F4 again, and it locks only the row. Hit it again and it locks only the column. Once more, and it unlocks it all back to x1.
It takes a little getting used to, but if you've figured out what the difference is between COPY and MOVE, then it should make sense.
Good luck!