COUNTIF & data validation from a drop down
 

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

--
kelly m johnson
UK

COUNTIF & data validation from a drop down
 

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

COUNTIF & data validation from a drop down
 

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

OR

try:

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

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

--
kelly m johnson
UK

COUNTIF & data validation from a drop down
 

Thank you to you both!!
--
kelly m johnson
Great Britain


"Gord Dibben" wrote:

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