I didn't realise that you could use relative reference in named ranges
I use a bunch of standard names ranges in my template sheets Book.xlt and Sheet.xlt. Here are two:

Me (refers to the cell in which the reference appears). Suppose you have a named range tbl that starts in A2, and you want to show the sum of the column where the formula appears (the formula is not in the table). Then you can use this draggable formula: =INDEX(tbl, 0, COLUMNS($A$2:Me))

relAbv refers to the cell above, so you can do =SUM(A1:relAbv). You can insert rows immediately above the formula and they will always be captured in the sum.