Office 2007 - Excel formulas not copying correctly?

If you are moving formulae but want to keep the same cell references in the formulae, use Absolute references to the cells. Absolute references are made by using $ in front of the column letter to keep the column letter constant and the $ is used front of the row number to keep the row number constant. If you use $ in front of both like this $C$14 the reference will always be to cell c14 no matter how you move the formula around. If the cell referenced is on a different sheet, say, sheet 3 cell C4 the reference would be entered Sheet3!$C$4. No matter where the formula is moved, the reference to that particular cell will remain constant.