This ALMOST works, DaveF, but only for a question with ALL yes
answers. All yesses get 100% but if there is one no and the rest yes,
I get 66.67% instead of 90%. And no clue how to make it think like my
boss, LOL


"Dave F" wrote:

You're welcome.

Try: =COUNTIF(A1:A100,"Yes")/COUNTA(A1:A100)

Dave
--
Brevity is the soul of wit.


"Meenie" wrote:

Thank you DaveF for "=COUNTIF(A1:A100,"Yes")"
That worked wonderfully... NOW I need to know how to
make it show the percentage - ie - if there are 13 questions and
13 are answered "yes" that would be 100%, if 12 answered yes it
would be 90%, 11 = 80%, etc. The number of questions may vary, but
if all questions are answered yes, it will always be 100%, if one is
answered no, 90%, etc.
(Does this make sense? yikes)
Thanks!