Hi

Im using a

=SUMPRODUCT((Sheet1!B3:B1001=1)*(Sheet1!C3:C1001=" RM")*(Sheet1!E3:E1001))

to locate the month first indicated by #1 the Code RM to add up the totals
I would like to search one more field however I need it to search with a wildcard

for ex. ABC*****

I've tried using the * but its not working, I think its because I'm using it in the formula

can anyone advise me on how I would do this?

Thanks