Hi folks,

Thanks to help from the excellent Ron Coderre I have the following which works a treat:

=COUNT(1/FREQUENCY(IF(ISNUMBER(SEARCH({"Anxiety","Depression","Bipolar Disorder"},C2:C14&D2:D14&E2:E14&F2:F14)),ROW(C2:C14)),ROW(C2:C14)))

The idea is to have a formula to count the number of rows(clients) who have at least 1 or more of the options:

I tried to extrapolate from this to a bigger more complex formula and it doesn't work, perhaps because I'm an idiot:

=COUNT(1/FREQUENCY(IF(ISNUMBER(SEARCH({"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"},'Data Sheet'!S6:AA6&'Data Sheet'!S7:'Data Sheet'!AA7&'Data Sheet'!S8:AA8&'Data Sheet'!S9:AA9&'Data Sheet'!S10:AA10&'Data Sheet'!S11:AA11&'Data Sheet'!S12:AA12&'Data Sheet'!S13:AA13&'Data Sheet'!S14:AA14&'Data Sheet'!S15:AA15&'Data Sheet'!S16:AA16&'Data Sheet'!S17:AA17&'Data Sheet'!S18:AA18&'Data Sheet'!S19:AA19&'Data Sheet'!S20:AA20&'Data Sheet'!S21:AA21&'Data Sheet'!S22:AA22&'Data Sheet'!S23:AA23&'Data Sheet'!S24:AA24&'Data Sheet'!S25:AA25&'Data Sheet'!S26:AA26&'Data Sheet'!S27:AA27&'Data Sheet'!S28:AA28&'Data Sheet'!S29:AA29&'Data Sheet'!S30:AA30&'Data Sheet'!S31:AA31)),ROW('Data Sheet'!S6:AA6)),ROW('Data Sheet'!S7:AA7)))

Each separate data sheet reference is a row for an individual person. Could anybody suggest why this would be totaling to 0?
I suspect I have messed up the bins!

Thanks in advance,


P.S I am a terrible person and have a linked post: http://www.mrexcel.com/forum/excel-q...y-formula.html