View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jpmurray22 jpmurray22 is offline
external usenet poster
 
Posts: 6
Default count percentages

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