wildcards in sumproduct functions
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 -
|