Thank you very much. I knew I must have been trying to make this harder than
needed...

" wrote:

a combination of the countif and counta functions would do it for you

=COUNTIF(A1:A4,"yes")/COUNTA(A1:A4)