Search results

I have put a data validation list in the cells so that the user has to choose either yes or no, however, it seems the formula isn't taking these results into account. It works perfectly when I type the words in manually, is there a way I can get the formula to register these results? Thanks again

Thanks, I'll have a look into it. Good to know how it works now!

Wow, that's great! Thanks alot mate you're a star! I appreaciate your help :)

Yes, the blank spaces can be ignored, I know I've seen something to do that before but I can't remember or find it. :o

Hi, thanks very much for the reply. I realise I had worded my question wrong. I was trying to get a percentage of yes's comapred to the total number of respones in a selection area. So I guess I need to find the value of yes's divided by yes's and no's, I tried...

Hi, I want to create a formula to calcualate to calculate the percentage of yes's compared to no's in a table. The closest thing i could find was =countif(a1:a10,"yes")/counta(a1:a10) or =countif(a1:a10,"yes")/10 but there could be a different number of results recorded and I only want...