Suppose the series of Ns and Ys is entered in the range B1:T1 (as er
your example), then to count 3 Ys, use the formula:
=FIND(("N"&REPT("Y",3)&"N"),(B1&C1&D1&E1&F1&G1&H1& I1&J1&K1&L1&M1&N1&O1&P1&Q1&R1&S1&T1))
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=378220