Thanks for your help. You guys are truly great and "spot on" with the
correct answers. I've learned a lot from you all.
"Pete_UK" wrote:

Hi Biff,

there are times when our answers are so similar ....

Spooky !! <bg

Pete

On Feb 18, 12:55 am, "T. Valko" wrote:
SUMPRODUCT doesn't accept wildcards.

Try something like this to count cells in A1:A10 that might contain "ABC"
anywhere within the cell:

=SUMPRODUCT(--(ISNUMBER(SEARCH("ABC",A1:A10))))

Note that case is not factor. ABC is the same as abc.

If in your application case *is* a factor then replace SEARCH with FIND.

Using FIND, ABC is not the same as abc.

--
Biff
Microsoft Excel MVP

"K1" wrote in message

...



I would prefer to use a wildcard for text criteria in sumproduct counting
and
adding equations. I have tried versions of "*ABC*" and get false values.- Hide quoted text -

- Show quoted text -

.