Calculating percentage of non-numeric values.

  • Thread starter Thread starter pharmer8
  • Start date Start date
all of them together equals 100 percent.
Yes's divided by Yes's plus No's times 100 is the percent Yes's. Same
way with percent No's, or subtract Yes percent from 100 to get No percent.
 
If you have 10 responses and 6 are Yes, what's the Yes percentage? It's:
=6/10
which equals 60%.

So you want a formula something like:
=countif(a1:a10,"yes")/count(a1:a10)

Regards,
Fred.
 
I bet you wanted =counta() in the denominator:

=countif(a1:a10,"yes")/counta(a1:a10)

or maybe:
=countif(a1:a10,"yes")/10

(if there could be empty cells)
 
Yup. Thanks for catching this. Fred.

Dave Peterson said:
I bet you wanted =counta() in the denominator:

=countif(a1:a10,"yes")/counta(a1:a10)

or maybe:
=countif(a1:a10,"yes")/10

(if there could be empty cells)
Click to expand...
 

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

Calculation of average improvement? 0
calculate percentage of cells that have any value 6
Negative percentage in data verification dropdown list? 2
Percentage remaining 5
Access Group by precinct, calculate percentage of older voters 0
Percentages 2
Calculate percentage 3
Rolling Year-to-Date Percentages 3

Back
Top