Hi Michele

this solution was posted by harlan grove to a similar question asked
recently

=LOOKUP(2,1/(-E1:E10<0),E1:E10)

where E1:E10 is the range you've interested in, change as necessary

Regards
JulieD

"Michele" wrote in message
...
the template for a check register has a running balance.... fine... i also
need the balance to read in a staionary cell at the top of the page so i
don't have to scroll down to get the balance....HELP