for yes
=COUNTIF($D$3:$D$292,"yes")
for no
=COUNTIF($D$3:$D$292,"no")
for % yes
=COUNTIF($D$3:$D$292,"yes")/COUNTA($D$3:$D$292)
for % no
=COUNTIF($D$3:$D$292,"no")/COUNTA($D$3:$D$292)

Use countA so in case any cells are not filled in with yes or no or you have
blank cells in the range you will get the correct percentage. Dividing by
290 will give the wrong answer unless all the cells have yes or no.



"T. Valko" wrote:

I formated the cells to custom "yes";"yes";"no".

I'm curious to know why you would do that?

That means if a positive or negative number is entered it displays as "yes"
and if a 0 is entered it displays as "no".

And if the TEXT entries "yes" or "no" are entered they aren't affected.

Are there TEXT entries "yes" and/or "no" in this range?

Perhaps you need to explain a little more.


--
Biff
Microsoft Excel MVP


"ksibly" wrote in message
...
I have a colum D3 thru D292 which has answer yes or no. I formated the
cells
to custom "yes";"yes";"no".

I want to have a formula that counts the number of yes's and no's. Then
formula to show the percentage yes vers no answers of the total of 292
answers.