Logic problem with countifs.....stripped urls

[splreece78]

afternoon all,

a silly one, but am lost...


my formulae is

=countifs(Conversion!C:C,D18,Conversion!F:F,E18,Conversion!J:J,F18,Conversion!P:P,G18,Conversion!M:M,H18,Conversion!Q:Q,I18)


What i am doing here is countifs if each column includes a referenced profile criteria.... and its stopps working after the 4th so i am hoping its a formatting or logic issue and not that excel wont accept more than 4.


(incase its needed).

the structure is

Column
C, F, J, P, M =True or False

Column
Q = Small Medium or Large


any ideas?

 

[splreece78]

Ohh also, they are all 'ands'... so count = c&f&j&g&m&Q