Sumif total using wild card

[srizki]

I have drop-down account numbers is H516, formula in J516 works fine, but I want to add total in the list of account numbers, in cell H516, to get total off all the accounts.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=SUMIF(B460:B513,"*"&H516&"*",L460:L513) <o></o>
<o> </o>
How can I do this.<o></o>
<o> </o>
Thanks.<o></o>
<o> </o>
Sohail <o></o>

 

[xld]

=SUMPRODUCT(--(ISNUMBER(MATCH(rng,B460:B513,0))),L460:L513)

where rng is the range of values being used in the dropdown in H516

 

[schielrn]

Maybe try:

=sumproduct(--(isnumber(find(h516,b460:b513))),l460:l513)

Hope that helps.

 

[srizki]

Thank you to both of you, although both formula are almost identical, I used schielrn formula, because xld's Match, formula can not work on my data, since in column B, I have numbers like 18600-2456, 18700-1234, etc.
But again, my original formula does the same, I need a formula that can do sum of all the accounts. what do I have to do to get it.

Thanks again.