wildcard help

[RX7ED]

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

[samprince]

=IF(ISERROR(SEARCH("ABC",Ax)),0,1)

May be handy,