Why not to use:
="there is = " & COUNTIF(A2:A13,"yes") & " yes"
assuming data are in column A