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.
|