Need a formula that reads only the last cell

[Nan]

I have a column of data where each week a new entry is made at the en
of the column. At the bottom of my spreadsheet there are totals. I
there a formula that I can enter in my Total that reads only the las
entry of the above column? In the below example, I would want my Tota
for this week to read 3859. I would like this to update automaticall
each week.


Calls
989
1731
2835
3859


Thanks for any help

 

[Frank Kabel]

Hi
if you have no blank rows in between use the following formula
(assumption values are stroed in column A)
=OFFSET($A$1,COUNTA($A:$A)-1,0)

 

[Nan]

Thank you!! :