countif function in multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=SUMPRODUCT(COUNTIF(INDIRECT("'"&ROW(INDIRECT("1:15"))&"'!B51"),{"Y","N"}))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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
 
You should have asked earlier <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top