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