"kounoike" wrote in message
...
assuming the sum is located in a13, then name a13 as e.g. pos.
using this name, put a formula like
=SUM(INDIRECT("a1:a"&ROW(pos)-1))
in a13.

above is redundant, no need to use name, just
=SUM(INDIRECT("a1:a"&ROW()-1))
would work for me.

keizi