You are not specifying which column or rows you are using. As such I cannot
be specific. You will therefore have to adapt the formula to suit your needs.

Let's say your balance rows are 10 - 24 in Col G.
Where you want the final balance insert

=OFFSET(G10,COUNT(G10:G24)-1,0)

The purpose being to count the non-empty rows, and read the offset row from
line 10, minus 1 row.

This obviously means that you should not have empty rows in between,
otherwise the formula would not work.

--
HTH

Kassie

Replace xxx with hotmail


"Challenged" wrote:

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