=LOOKUP(99^99,a:a)
It will return the last occupied cell in A-column
Place the formula in the cell you need.
best wishes
Sreedhar

"itsmemike" wrote:

How do i copy the last cell containing a value from a column to another blank
cell. I have entered a sum formula into the first cell and copied it down the
column but will not always fill all the cells, in a cell at the bottom of the
cell i want to show the last balance.