Counting Number of Occurrences in worksheets
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.
|