If you have a drop down box where you can choose the different options "yes, no etc" the cell showing the result would have a countif formula, = countif ( your range of results , the cell location of the drop down box ie "F3" ) - 
=COUNTIF(A1:A200,F3)