You should have left it as GENERAL.

Formatted as GENERAL and if you're entering the text values of "yes" or "no"
then Joel's formulas will/should work.

--
Biff
Microsoft Excel MVP


"Ksibly" wrote in message
...
New at this thought to get the correct number would need to change the
cell
format. Should I have left it a general or Text?

"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.