Finding the percent of Yes answers pt 2

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
 
R

Ron Coderre

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
 
Top