=countif(e1:e20,"yes")/20
(E1:E20 has 20 cells)
format as percentage.

or
=countif(e1:e20,"yes")/(countif(e1:e20,"yes")+countif(e1:e20,"no"))
this is equivalent:
=countif(e1:e20,"yes")/sum(countif(e1:e20,{"yes","no"}))





cybergardener wrote:

Can I get a percent ratio from multiple columns that uses letters or
characters? For example 4 columns with random Yes or No answers, 3 yes, 1
no, should show in Column E 75% in favor of Yes.

There are also similar columns with the + and - signs instead of a word or
numbers. Can these symbols be calculated?
--
Thanks
Cyber Gardener

--

Dave Peterson