How do I reference the last row and selected cell/s?

[Guest]

I have data in a dynamic database and require the total amount of
selected cell(s) on the last row to be displayed on another sheet.

 

[Alex Delamain]

I'm not sure if this is exactly what you want but here goes anyway...

If your database runs from say A1 to Z10000 with headings in row A

=OFFSET($A$1,COUNTA($A:$A)-1,0)

will return the value in the last row of column A whichever row it i
in. The same can be done for the other column

 

[Guest]

Thanks Alex, exactly what I wanted.