View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark
 
Posts: n/a
Default SUMPRODUCT WITH WILDCARD

Can someone assist me with a formula to sumproduct with wildcards, please?

=SUMPRODUCT(--(F:F="NPT*"),--(A:A="PC*"))

I've got this but it doesn't work!!

--
Mark