View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eddy Stan Eddy Stan is offline
external usenet poster
 
Posts: 151
Default help on sumproduct() - sum by searching for a common sub strin

to remind again...
the search string may be anywhere in each cell of dregion range.
for example - "Transport" is prefixed by location name in 3 letters suffix
by 3 letter salesperson, with space in between.
That is why i put xxxx before / after search string in my query.