View Single Post
  #4   Report Post  
Old February 18th 10, 01:12 AM posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default wildcards in sumproduct functions

Hi Biff,

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

Spooky !! <bg


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:


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.

Microsoft Excel MVP

"K1" wrote in message


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

- Show quoted text -