Hi,

If you want to know the last numeric entry in range D4:D18, you may use
=LOOKUP(99^99,D4:D18)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Challenged" wrote in message
...
Hi... I'm working with a Billing Statement in Excel. Going down the colum
is
the sum of charges and credits from the two columns from the left. The
billing statement i'm working with is rather standard. I'm simply trying
to
take the balance on the last line (the sum of the above line
charges/credits)
and place that dollar value in a "Current Balance Due" field at the bottom
of
the statement. What is the named function I use to say, "take the last
current balance dollar value and put it in the Current Balance Due Field"
which I'm trying to create? Since the number of lines (charges/credits)
in
billing statements varies, I need the formulae to know to look only to the
last line of any series to copy, not a fixed line.
--
Greatly appreciated!
Thanks
Gene