Microsoft Excel yes no drop down list

1. Select your range, then go to Data menu --> Validation

2. Select the Settings tab, in the Allow field, select List, then in Source type

Yes,No (without spaces).

You are set to go.

Now if you want to count those Yes or No, use

=countif([Range of Cells], "Yes")