software

I have the following type data and need to first lookup by the dealer # and
then count the model number but need to use wild cards.

I can use =COUNTIF(DATA!A2:G1034,quot;8EC*E*quot;) for all dealers combined but can
seem to cound by dealer?
Please help!

col B col C
49930594F25NL
49930594F55NL
49930598EC5EC
49930598EC5EL
49930598ECXE9
49930598ECXEH
49930598EDXEL
49930598N35BL
49930598PA51L
49930598PA52X
49932504BH57Z
49932504BH57Z
49932504E251L
49932504E251L
49932504E251L
49932504F255L
49932504F255L
49932504F255L
49932504F255L
49932504F255L
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F25NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932504F55NL
49932508EC549
49932508EC549
49932508EC5E9
49932508EC5ECHi!

Use 2 cells to hold the criteria:

D1 = 4993059
E1 = 8EC*E* (might be better to use 8EC?E? since the ? wildcard represents
only a single character)

=SUMPRODUCT(--(B1:B47=D1),--(ISNUMBER(SEARCH(E1,C1:C47))))

Biff

quot;DRvfrquot; gt; wrote in message
news
gt;I have the following type data and need to first lookup by the dealer # and
gt; then count the model number but need to use wild cards.
gt;
gt; I can use =COUNTIF(DATA!A2:G1034,quot;8EC*E*quot;) for all dealers combined but
gt; can
gt; seem to cound by dealer?
gt; Please help!
gt;
gt; col B col C
gt; 4993059 4F25NL
gt; 4993059 4F55NL
gt; 4993059 8EC5EC
gt; 4993059 8EC5EL
gt; 4993059 8ECXE9
gt; 4993059 8ECXEH
gt; 4993059 8EDXEL
gt; 4993059 8N35BL
gt; 4993059 8PA51L
gt; 4993059 8PA52X
gt; 4993250 4BH57Z
gt; 4993250 4BH57Z
gt; 4993250 4E251L
gt; 4993250 4E251L
gt; 4993250 4E251L
gt; 4993250 4F255L
gt; 4993250 4F255L
gt; 4993250 4F255L
gt; 4993250 4F255L
gt; 4993250 4F255L
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F25NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 4F55NL
gt; 4993250 8EC549
gt; 4993250 8EC549
gt; 4993250 8EC5E9
gt; 4993250 8EC5EC
gt;