I need to do a conditional count (how many rows are there where the following
conditions are both true). One condition is, does a cell that contains
multiple text strings (DEF5678, GHI6789, ABC1234) contain the text string
ABC1234? If that condition is true, is the second condition also true? Tell
me how many records there are where both conditions are true.

I'm very familiar with array formulas
{=sum((array1=ABC1234)*(array2=test2))}, and I'm familiar with searching for
text strings (=countif(B2:B100,"*"ABC1234"*").

Any thoughts?

Steve