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.