Check out this link...

http://www.xldynamic.com/source/xld.LastValue.html
--
HTH...

Jim Thomlinson


"David M" wrote:

I have 4 sheets each containing a running balance that as a transaction is
posted the balance moves to the next cell down. Example: balance is currently
in F4, I make a post that will change that balance and it will now be
displayed in F5.I want to have a summary sheet that will show the current
balance for all 4 accounts. Per some of the other posts regarding dynamic
ranges I've been trying to use
=offset(sav1!$F3,0,0,counta($F:$F),1) I've also tried the same but using
match(9999999,$F:$F) instead of count and still I am not getting the current
balance. Any help would be greatly appreciated.