reconciling countif?????

[esquared8]

I'm head deep in reconciling countif formula... I have a spreadsheet containing 465 rows of data. Each question is tied to a subtopic. I've used a countif formula to count how many times I'm using all of the topics. I come up with 491 uses of all subtopics. How can this be if I only have 465 questions? Each question is only tied to 1 subtopic.

I've checked every countif formula and it is indeed giving me the correct number. ex: aprs is used 3 times, pricing request is used 13 times, etc. they are all correct.

Why won't the total number of questions match the total number of times a subtopic is used?

 

[jmthompson]

phooey! Check you inbox, I sent you my e-mail addy if you want to send me a copy of your file, I will take a look to see if I can find anything.

 

[esquared8]

phooey is right - I had one of my topics listed twice in the summary.

Thanks, everyone, for helping and giving me things to think about to figure this out!