Count cells that are numbers and do not equal either x or y

=SUMPRODUCT(--((ISNUMBER(FIND("*chars1*",CellRange)) + ISNUMBER(FIND("*chars2*",CellRange)) ) > 0)
blank


© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top