Countif assistance

[Schubby10]

Hey guys looking for assistance with my countif formula.
I have a number of vendors in column D and different account numbers in column C. I am looking to count all the instances of this particular vendor but only counting it once every time it hits an account.

Acct are strucutre 123-123-abcde-1234-1234. the abcde is the part I need to differentiate each account.

Here is my formula but it does not seem to work.

countifs(mid(C$4,9,5):mid(C5,9,5),mid(c5,9,5),D$4:D5,D5
any suggestions on how to make this work?

 

[Eric W]

Can the abcde part appear in any other part of the account number? If not, you can use wildcards to locate the vendor. Something like this:

=COUNTIFS(C4:C100,"*"&MID(C5,9,5)&"*",D4:D100,D5)