I am currently trying to solve a formula and am unsure as to what the best way to go about it is.
I want to count 1 if the following conditions are met:
A = no
B = any text
C = any text
D = any text
E-J = at least one has any text
If all these conditions are met, count 1.
I've tried...