Getting the value from the last row in a table

[don075]

I have an excel sheet with multiple tables defined (FIN, AR, MT...etc)

Each table has the same column structure (Income, Expense, Total).

From Each table, I need to get the value from the Total column in the last row and display in another sheet.

My question is how to I get the last row value.

Ex: In my FIN table, the Total is in column F

FIN table has 6 rows. This will be increased every day during data entry.

I need to access the Total in the last row of FIN table and show in the second sheet.

I can get the no of records in my table by using Rows(FIN) function.

So, if I have 6 rows, I need to get F6. If I try to use string concatenate F & rows(FIN), it doesn't work. Error out. Any way that I could get the value from the last row? 

[#2 · Accepted solution]

@don075 Try this:

=INDEX(FIN[Total],ROWS(FIN))

[#3]

Thanks that works.

[#4]

Thanks!

Paul