count percentages
=COUNTIF(A2:A500,"yes")/COUNTA(A2:A500)
format result as percentage
--
Regards,
Peo Sjoblom
"jpmurray22" wrote in message
...
Is there a way for me to find out the percentage of "yes" answers in the
following example. I know that there are 4 yes and 2 no, but is there a
way
to divide 4 by the total number of cells, for when my list becomes
hundereds
of cells long?
yes
no
yes
yes
yes
no
4
|