Thread: Wildcard character inside sumproduct
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Wildcard character inside sumproduct
Hi,

Wildcard character won't work inside sumproduct ...
My recommendation would be to use Left() Mid() Right() functions
which do work inside sumproduct() functions ...

HTH
Carim

Reply With QuoteReply With Quote