Need help with Count excluding duplicates when using a table

[Golfpro1286]

I have a table of data that contains the following columns. I am trying to count the number of loans each officer has made. In order to have a slicer on the dashboard to switch between combinations of New/Refi funds some loans can be duplicates. Can someone help me with a formula to count the loans an officer makes excluding duplicates that occur in the "Funds(New/refi)" column. This will show in a separate tab that has other loan information the cell references below are on that tab.

I would like to count the counting field to be the Loan # Column and to exclude duplicates.
Here are the ifs that need to apply: Date <= cell G2; Date >= cell K2; Officer = cell A10; System = "CL";

In the example below the count should be 3 even though there are 5 entries, there are 2 duplicates (in red).

[TABLE="class: grid, width: 1000"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Officer Name[/TD]
[TD]Borrower[/TD]
[TD]System[/TD]
[TD]Loan #[/TD]
[TD]Funds(New/Refi)[/TD]
[TD]Loan Amount[/TD]
[/TR]
[TR]
[TD]10/1/18[/TD]
[TD]Officer 1[/TD]
[TD]Borrower 1[/TD]
[TD]CL[/TD]
[TD]123456[/TD]
[TD]New[/TD]
[TD]$5,000.00[/TD]
[/TR]
[TR]
[TD]10/1/18[/TD]
[TD]Officer 1[/TD]
[TD]Borrower 1[/TD]
[TD]CL[/TD]
[TD]123456[/TD]
[TD]Refi[/TD]
[TD]$7,500.00[/TD]
[/TR]
[TR]
[TD]10/3/18[/TD]
[TD]Officer 1[/TD]
[TD]Borrower 2[/TD]
[TD]CL[/TD]
[TD]123457[/TD]
[TD]New[/TD]
[TD]$10,000.00[/TD]
[/TR]
[TR]
[TD]10/5/18[/TD]
[TD]Officer 1[/TD]
[TD]Borrower 3[/TD]
[TD]CL[/TD]
[TD]123458[/TD]
[TD]New[/TD]
[TD]$12,000.00[/TD]
[/TR]
[TR]
[TD]10/5/18[/TD]
[TD]Officer 1[/TD]
[TD]Borrower 3[/TD]
[TD]CL[/TD]
[TD]123458[/TD]
[TD]Refi[/TD]
[TD]$9,000.00[/TD]
[/TR]
</tbody>[/TABLE]


Thanks!

 

[Golfpro1286]

I ended up just creating a new column to dictate if it was a duplicate entry and added that to my current Countifs formula.