Hi Richard, this is probably coming up in a future lesson (I'm only on Beginner Level 2-3), but it's something I'm being asked to do now.  I need to create a spreadsheet for training.  I know how to insert a formula to get a total, but what if I'm not finished entering information?   If I put the formula in cell E24, but still have to enter other trainings after row 24, what do I do?  The only thing I can think of is that once I've put the formula into a cell, I'd have to insert a new row every time I entered a new training.  Is there a way to force that formula to move down?
I hope I've explained my question.

---

Reply from Alex Hedley:

If you highlight the cell and hover in the bottom right hand corner it should change to to black + sign
Double click that and the formula will copy down.