I think Dave meant something like with your data in A3:A20 rather than A1:A21
then you can use
A21: =sum(a$3:offset(a21,-1,0))

That's offset by one row upward, and 0 columns to the right