If you are doing a sum of your data tab, i.e.: =SUM(Data!$A$2:$A$100), have
you verified that your data tab is not extended beyond row 100?
--
John C


"Knucklehead" wrote:

I have a summary page that pulls numbers in based on account numbers from a
detail spreadsheet. Column A is the account number, Column B is the amount
on the detail spreadsheet. Is it possible to do some sort of trace function
to see what numbers are not going into the summary worksheet? I haven't had
this error before and there is not one amount that comes close to matching
the difference from the summary sheet to the detail sheet. Hope this makes
sense.