excel formula

RevTimms

I have a column of figures on my spreadsheet. eg A3 to A41.
I will sometimes be adding to the column and sometimes deleting from it.
eg delete A5, or adding another figure eg at A42.
Elsewhere on the spreadsheet I want, the first one and the last one totalled, but I don't want to have to keep altering the new cell everytime I add or delete a value.
Is there a formula which would do this for me?

[Deleted User]

There's no need to do anything, that's the way Excel works already. If you put =A3+A41 in the cell where you want the total, then it will automatically increment/decrement the references when you insert/delete lines. (If you don't want it to automatically alter references you use a dollar symbol in front of the part you want to freeze: =A$3+A$41)

WaywardDriver

If I understand it you want A3+Axx where xx = last row in column. If so try
= A3 + INDIRECT("A" & MATCH(, A : A,-1))
and remove all spaces.
[Part of earlier version without spaces was displayed as emoji]

DoaM

=A3+INDIRECT("A"&MATCH(,A:A,-1))

Without spaces.