Yes, but will try again.

"RagDyer" wrote:

The only way I can see you getting a #Name? error is misspelling a function
or a cell reference, or if your actual formula is using ranges that may be
non-existent or misspelled.

Did you copy Jacob's formula directly into your sheet from his post?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Terri" wrote in message
...
Unfortunately, I receive a "#NAME?" error when I try this formula. I
tried
it with and without spaces between the & and what follows. Not sure what
I'm
doing wrong. Thanks.

"Jacob Skaria" wrote:

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.