Count cells that contain 2 text strings
=SUMPRODUCT(--((ISNUMBER(FIND("*chars1*",CellRange)) + ISNUMBER(FIND("*chars2*",CellRange)) ) > 0)
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top
=SUMPRODUCT(--((ISNUMBER(FIND("*chars1*",CellRange)) + ISNUMBER(FIND("*chars2*",CellRange)) ) > 0)