Agree-the fundamental problem is that formulae are copied from cell to cell.

It is so easy to make a mistake on a big spreadsheet.

A much better approach would be to write user defined functions.