I have a project that entails calculating the number of times an answer
appears on a range of worksheets and inserting the result on my compilation
worksheet in the same file. For example:

Question Yes No Other
Do you like Sushi? X

I need to calculate the total number of "X" in the Yes, No and Other columns
from many separate worksheets in the same file.

I am using Excel 2002.

Any assistance would be appreciated. Thanks.