SUMPRODUCT filtered data and wildcard

[creative999]

Hi

Im using a sumproduct formula with a filter for a filtered list which works fine.
=SUMPRODUCT(SUBTOTAL(109,OFFSET(E5,ROW(E5:E100)-ROW(E5),,1)),--(F5:F100="RETAIL"))

But i now need to add a wildcard filter (value is in cell A1) for column G. I ve tried the following but getting 0 result.

=SUMPRODUCT(SUBTOTAL(109,OFFSET(E5,ROW(E5:E100)-ROW(E5),,1)),--ISNUMBER(FIND(A1,G5:G100)))

Any suggestions?

 

[Fluff]

Try using Search rather than Find.

 

[creative999]

Try using Search rather than Find.

Perfect - thank you.

 

[Fluff]

You're welcome & thanks for the feedback.