VLOOKUP COUNTIF help?

Hi all,

First post on this site, hope I get my answer

I've cut out all of the sensitive and extra stuff in my original table, instead of 150+ entries I've only included 11...what I'm looking for someone to help me with, is to create a formula for R6...

The drop down list in P6 allows you to choose a disease, then Q6 displays how many technology appraisals (TAs) there are...what I want, is to count how many of the selected disease has YES's in the VBA? Column (E).

I hope that makes sense? and If you'd like any clarification, let me know...finally, i'd like to be robust enough to still work even if the list is sorted in different ways? E.g by TA# (Column B)

Thanks!

sowdani

Appraisal Help.xlsx

Thats exactly what I was looking for, just had to clean up the text string with a few asterixs to include all the different 'cancers', but apart from that, PERFECT!

Thanks dude

sowdani