Hi.
I'm using this formula
=SUMPRODUCT(--(ISNUMBER(FIND(A1,$B$1:$B$30--($C$1:$C$30)) multiple times.
i.e. finding A2, A3 etc. Where A1 is text within a phrase. e.g. finding
"diesel", "unleaded", or "fuel" within phrases in B column like "bulk diesel
fuel", "fuel unleaded" etc
Is there an easy way to avoid overlaps for words in A1,A2...A10 without
writing a massive formula. ie sum A1's related value in C1 but not A2...A10 =
sum "diesel" but not "fuel" etc.

Thanks.