Count Yes/No

Hello All, I have an excel sheet where one column contains Yes/No and other Email IDs. I want to count the number of No till it encounters first Yes (Assuming first entry as No). Can someone help me...