Help with Count based on criteria for duplicates

[Hart001]

I am working with a set of data and I am looking to count the total occurrences for column "B" that begins with the number "1" and also is less than or equal to date from column "C" (without time), for example <=12/26/22. Also, I am wanting this same information minus the duplicates, where duplicates would only count 1.

Example.xlsx

[CARACALLA]

E3=SUMPRODUCT((LEFT(B2:B161,1)+0=1)*(INT(C2:C161)<="12/26/2022"))


E6=SUM(IF(FREQUENCY(IF(INT(C2:C161)<="12/26/2022",IF(LEFT(B2:B161,1)+0=1,MATCH($A$2:$A$161&B2:B161,$A$2:$A$161&B2:B161,0))),ROW($A$2:$A$161)-ROW($A$2)+1),1))

Control+shift+enter

[Hart001]

EXAMPLE LOS.xlsxSample Data.xlsx

This worked perfectly!! Thank you so much! I am now working to have the formulas auto detect when new data is input into the spreadsheet and auto calculate using the formulas. I am seeing a #VALUE issue due to the columns A, B and I not updating the refecence to the last cell with data for the respective columns. With that the only way to update is to update all 14 formulas F3:M4 with the last cell reference. Any help would be greatly appreciated and I have attached the input spreadsheet as well as an example data to input in order to see what I am reffering to live.