Can I combine Sumproduct and Countif formula in Excel? Please help

[Struggling Analyst]

Hi All,

I'm working on a project and I need help combining these two formulas:

SUMPRODUCT(ISTEXT('Commitment Report'!H3:H1513)*('Commitment Report'!H3:H1513<>"")/COUNTIF('Commitment Report'!H3:H1513,'Commitment Report'!H3:H1513&"")

and

COUNTIF('Commitment Report'!AL:AL,"Cayman Branch")

Basically I have a list of approx. 1500 trade positions that are split between 8 branches, Cayman Branch being one of them. I need to count the number of borrowers for each branch without duplicating the count.

For example, Cayman Branch has 1027 trades and 841 borrowers, but I don't know how to calculate the borrowers without duplicating.

Is is possible to combine these two formulas to tell me the count of borrowers without duplicating?