survey results

S

scottmccoon

I have compiled a community survey and have lots of yes/no questions
and need help with functions on how to average number of yes's to no's.
 
G

Gord Dibben

Don't know what you mean by "average yes's to no's"

Do you mean get a percentage of each?

Assuming a range of answers in A1:A50 with either yes or no in each cell.

=COUNTIF(A1:A50,"yes")/COUNTA(A1:A50)

will give you the percentage of yes's in the range.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested Ifs in 2007 4
Prefilled Outlook Yes Voting Button response 0
bunch of "yes" or "no" entered in row, output 1 if a single yes 18
Lining up rows based on values 1
Survey Form And Tracking Results 4
Hostname from IP address 1
Adding sum of "yes" 6
display answers to a questionnaire in a chart 2

Top