COUNTIF & data validation from a drop down

K

Kelly 1st

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")"
 
G

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
 
T

Toppers

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

OR

try:

=COUNTIF(D10:D14,"No*")
 
Top