countif function in multiple worksheets

G

Guest

I have been trying to use the countif function to count the number of times a
"Y" response occurs in a specific cell in 15 different worksheets that are
all in one workbook. ... I have tried
=SUM(COUNTIF('1:15'!B51,{"Y","N"}) but I keep on getting a "value error".
This formula works in one worksheet but it wont count multiple worksheets.
I've been trying to solve this for days by myself but I'm stuck. I'm a new
user and really would appreciate any help.

Thank you
 
B

Bob Phillips

=SUMPRODUCT(COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:15"))&"'!B51"),{"Y","N"}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Bob Thank you Thank you Thank you.... I have been working on this for days
and you solved it for me . I really appreciate your help
 
B

Bob Phillips

You should have asked earlier <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF across worksheets 3
Countif in multiple worksheets 6
incrementing worksheet name in a countif function 0
COUNTIF Formula in Multiple worksheets. 14
COUNTIF: everything in a row larger than zero over multiple worksh 1
COUNTIF function help please 8
countif across worksheets 4
countif from different worksheets 2

Top