Count data validation drop down values?

[ScarScarr]

Hi there,

I'm a little stumped at the moment, I have several columns in a sheet with drop down menus (made via data validation) offering values of YES or NO

I would like to be able to count the amount of times YES is chosen in each column seperately. i.e column C = 5, F=2 etc.

The list data is held on a seperate sheet (I dont know if that matters)

I've tried various IFCOUNT and SUMPRODUCT formula's but are all returning a count of 0 which I know there is not.

Any advice would be greatly appreciated!

Thanks, Scar

 

[p45cal]

check out COUNTIF rather than IFCOUNT

 

[ScarScarr]

Thanks for replying! Unfortunately I tried this earlier and it still returns a 0 count

 

[p45cal]

So what have you tried using COUNTIF?

 

[ScarScarr]

I want the count on a different sheet so I have used the below - it works with the columns that dont have drop downs (where I have just typed in a YES)

=COUNTIF('TSMS DB'!M5:M83,"YES")

It seems the drop down option once selected doesnt register in the cell with any formula I use???

 

[WhatTheXL]

Try Checking your Data Validation for trailing spaces.

"Yes " instead of "Yes"

 

[ScarScarr]

Trailing spaces is exactly what it was!!

Thank you so much cannot believe I didnt even check for that and have been confused for what has now been 4 hours! LOLZ

Thanks again for your help - your a star!!