"Bob Phillips" wrote...
That won't work as the syntax is wrong ("*2*"), and it is an AND not OR
test. What is closest is

=SUMPRODUCT((A1:A100=2)+(ISNUMBER(FIND("2",A1:A10 0))))

but this counts a single 2 twice, so all you need is

=SUMPRODUCT(--(ISNUMBER(FIND("2",A1:A100))))

as I gave previously.
...

If the last formula works, so would

=COUNTIF(A1:A100,"*2*")

no?

--
To top-post is human, to bottom-post and snip is sublime.