Maybe that's not all the cell contains?

Any extra spaces in the cells?

In E10 enter =TRIM(D10) copy down to D14

Use your countif on E10:E14..........any better?


Gord Dibben MS Excel MVP

On Tue, 5 Jun 2007 10:27:01 -0700, Kelly 1st
wrote:

Hey

Could someone help...

I have yes/no/N/A list in various cells

i would like to cout how many no's there are

when i use the countif formula, it won't work and returns the value of 0
when clearly a cell has a no in it.

i'm using "=COUNTIF(D10:D14,"No")"