View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
k1 k1 is offline
external usenet poster
 
Posts: 7
Default wildcards in sumproduct functions

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.