Finding the percent of Yes answers pt 2

  • Thread starter Thread starter Dude
  • Start date Start date
D

Dude

The initial formula, =COUNTIF(H4:H33,"Yes")/COUNTA(H4:H33), works great.
But, no let's say that besides Yes and No answeres, there are n/a answers.
How do I account for this in the formula.

Excel XP SP2
 
If you only want to include "Yes" and "No" answers in your calculations, here
are two options:

=COUNTIF(H4:H33,"Yes")/(COUNTA(H4:H33)-COUNTIF(H4:H33,"n/a"))
or
=COUNTIF(H4:H33,"Yes")/SUM(COUNTIF(H4:H33,{"Yes","No"}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
You must log in or register to reply here.

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

Help - Finding the percent of Yes answers 5
Indexing/Matching True/False results 5
Query- Totaling yes answer an the calcuating the percent of the to 2
Returning a YES or NO if there is a value on a range of cells 0
Problem not counting duplicates 1
Need help with formula to weed out duplicates 4
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
Help, I need a formula for work. 7

Back
Top