- Joined
- Aug 4, 2014
- Messages
- 1
- Reaction score
- 0
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?
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?