Need a formula that reads only the last cell

  • Thread starter Thread starter Nan
  • Start date Start date
N

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
 
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)
 
Back
Top