COUNTIF & data validation from a drop down

[Guest]

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(D1014,"No")"

 

[Gord Dibben]

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

 

[Guest]

Check if cells have added blanks e.g "No " will not match

OR

try:

=COUNTIF(D1014,"No*")

 

[Guest]

Thank you to you both!!