I am trying to use this logic
((1 OR 2) OR 6 OR 7 OR 8)) AND 3 AND 4 AND 5
I tried this but, it is not retuning the right count
((Column1 ='Yes' OR Column2 ='Yes')
(Column6='Yes' OR Column7='Yes' OR Column8='Yes'))
Column3 = 'Customer'