By using the following formula, I can return whether categories A, B, and C all contain a value >0 for any given sample. =IF(AND(A>0, B>0, C>0), "yes", "no") I would like to be able to create a formula that could look at all combinations of 3 or 4 cat...