Help - Finding the percent of Yes answers

D

Dude

I have an 80 line column with Yes/No answers (Y=yes and N=no), and I need to
find the percentage that were marked Yes. For example, let's say there are
63 Yes and 17 No answers. That would be 78.75% were marked as Yes.

Excel XP SP2
--
 
D

Dude

Thanks you guys.

Ron Coderre said:
Try something like this:

=COUNTIF(A1:A80,"Y")/COUNTA(A1:A80)

Format that cell as percent

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

XL2002, WinXP
Click to expand...
 
B

Bob Phillips

=AVERAGE(IF(A1:A100="Yes",A1:A100))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
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
 
Top