What is the first reference within the formula? ALso, the outstanding checks
are on one worksheet and yes the total will be the last numeric value in the
column. The place that I want the reference to go is on another worksheet.

"T. Valko" wrote:

So, is this total cell the *last* numeric value in the column? If so, try
this:

With the total cell somewhere in column B:

=LOOKUP(1E100,B:B)

--
Biff
Microsoft Excel MVP


"marcia2026" wrote in message
...
I have one worksheet which lists all of my cancelled checks with a total at
the end. I want to referrence that total on the Reconcilation worksheet.
How do I reference a cell if that cell address changes each month?

marcia