One other way of explaining it is - I don't know how many entries I will put in to the worksheet but at the same time I need a formula at the bottom of the sheet that will keep a running total of some simple values that the entries provide.

I think it is absolute cell referincing that tracks and updates data change/position change in worksheet