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.

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.

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.

"John C" wrote:

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.

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.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Knucklehead" wrote:

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.

"John C" wrote:

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.