CountIF not "counting" yes, no, n/a from a Dropdown list correctly.

[arooney88]

Hey everyone, having a big issues with a report I'm working on.

I have columns that people input data into the cells using a dropdown that lists out:
yes
no
n/a

I'm trying to count the number of yes and no in my columns. I'm using =COUNTIF(my cell range, "yes) and =COUNTIF(my cell range, "no")

It's counting the yes' correctly but not counting and 'no's. It's the same formula so I'm really confused on why it's not adding up one item correctly.

Any help??

 

[skbailey11]

Just a couple thoughts. When you typed the formulas here, you have a typo and are missing a " after the yes. I would verify that your formulas don't have a typo that you're just not seeing. Also, verify that your criteria actually matches the dropdown list. Maybe the list yes has a space after it that you're not seeing. People at my work are always typing in extra spaces.

 

[arooney88]

Sorry no typo in the actual formula ( just on here, my bad). The space might be an issue...I'll have to go through and check them. Thanks!

 

[Brian from Maui]

To check try using the LEN function

=LEN(A1) and copy down

Where A1 houses Yes or No. It should return 3 for Yes and 2 for No

 

[arooney88]

Let me try this quick. Fixed it.

 

[arooney88]

To check try using the LEN function

=LEN(A1) and copy down

Where A1 houses Yes or No. It should return 3 for Yes and 2 for No

THANKS this worked. Whoever put the dropdown inputs added a space after No so it was looking for 3 characters. Lifesaver!