I wasn't sure if my response went through or not, so
excuse me if this is a duplicate. Tom, I appreciate your
response. I tried to enter the formulas that you gave me
and they did not work. The first formula that you gave me
continued to show a 0.0% in the cell after I entered yes
and no information in the nine cells. The second formula
left a #DIV/0 in the cell after I entered yes and no
information in the nine cells. Can you tell me what I may
be doing wrong. If it would help to see the worksheet, I
would be happy to send it to you via e-mail if you would
leave me your e-mail address. My e-mail is
. Thanks again for the help.

Hi JY,

Tom's first formula worked fine for me as did his second formala, after
amending a small typo: change the last "yes" to "no"

I was able to get your results if I entered my yes/no data in cells outside
of the range $B$3:$B$11 specified in Tom's formulae.

Incidentally, you make it inordinately hard to help you by starting a new
thread.


---
Regards,
Norman



"JY" wrote in message
...
I wasn't sure if my response went through or not, so
excuse me if this is a duplicate. Tom, I appreciate your
response. I tried to enter the formulas that you gave me
and they did not work. The first formula that you gave me
continued to show a 0.0% in the cell after I entered yes
and no information in the nine cells. The second formula
left a #DIV/0 in the cell after I entered yes and no
information in the nine cells. Can you tell me what I may
be doing wrong. If it would help to see the worksheet, I
would be happy to send it to you via e-mail if you would
leave me your e-mail address. My e-mail is
. Thanks again for the help.