Getting the numbers correct

Hello Jason

Thank you for your question and welcome to the forum.

When you have selected a cell to put it into a formula, pressing the F4 key once immediately afterwards turns the cell reference for the selected cell from a relative reference (e.g. A4) to an absolute reference ($A$4). This 'fixes' or 'locks' the cell reference into the formula, so when the formula is copied to other cells in the spreadsheet, the reference to the cell stays the same.

Kind regards
Amanda