Formula for % of "yes" in range of cells?

G

Guest

How do I write a formula to determine a % of "yes" responses for a range of
cells. For example: Cells C2-C20, 12 of the 18 cells have "yes" the other 6
have "no". Cell C21 would have the % of yes. Thanks!!
 
B

Bob Phillips

=COUNTIF(C2:C20,"yes")/COUNTA(C2:C20)

and format as a percentage.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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

A find formul looking at two named ranges for two strings 6
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Excel VBA 1
Using the IF fuction for multiple cells 2
Formula Help 0
Calculating Cell Occupation 2
Match - #N/A 7
If yes then display information in cell 2

Top