Cells not included in formulas

[Knucklehead]

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.

 

[John C]

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?

 

[Knucklehead]

Yes - it is a SUMIF formula that is defined to row 400 and I cut it to 385
rows of data. I believe somehow there are new accounts that I can't figure
out that aren't defined in a SUMIF formula. I tried to line up the account
numbers from previous periods against this period and can't figure it out. I
am guessing a formula got changed somehow, or deleted. Thank you very much.

 

[M Kan]

Use a VLOOKUP to match the account numbers on the larger file against your
summary. Every value in the larger file that doesn't match a summary value
will result in a #NA error, which will help you narrow down what isn't
getting included.