With the sheetnames in range G1:G10; the below formula will return the count
of X in cell B2 in all sheets mentioned in the range G1:G10

=SUMPRODUCT(COUNTIF(INDIRECT("'"& G1:G10 &"'!b2"),"X"))

If this post helps click Yes
---------------
Jacob Skaria


"Terri" wrote:

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.