Try:

=COUNTIF($C$1:$C$72,"yes")/COUNTA($C$1:$C$72)

and

=COUNTIF($C$1:$C$72,"no")/COUNTA($C$1:$C$72)