hi
try this...assuming your amount column is A..change to suit.
=OFFSET(A2,COUNTIF(A2:A500,"0")-1,0)
it uses the offset function to return a value offset in row and columns from
a point.
in this case point is a2, rows offset is what ever is in the column and
colunms offset is 0.
the countif function counts the rows for the offset function.

regards
FSt1

"DebbieV" wrote:

Hi

I was wondering if anyone can give me a formula for a spreadsheet that
I am maintaining a list of transactions and has an amount due column.

I want to have a seperate cell that will always have the last amount
that appears in the amount due column.

Is there a formula to identify the last entry in the column if I keep
adding entries in the rows.

cheers
Debbie