Help with Frequency formula that's dependant on a date

%3CLINGO-SUB%20id%3D%22lingo-sub-1590505%22%20slang%3D%22en-US%22%3EHelp%20with%20Frequency%20formula%20that's%20dependant%20on%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590505%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20with%20more%20formula%20knowledge%20than%20myslef%20help%20me%20with%20the%20following%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20the%20formula%20%7B%3CFONT%3E%3DSUM(IF(FREQUENCY(IF(ERRORS!D5%3AD1001%26lt%3B%26gt%3B%22%22%2C%20MATCH(ERRORS!D5%3AD1001%2CERRORS!D5%3AD1001%2C0))%2CROW(ERRORS!D5%3AD1001)-ROW(ERRORS!D5)%2B1)%2C1))%3C%2FFONT%3E%7D%20to%20count%20how%20many%20unique%20references%20I%20have%20in%20a%20table%20which%20works%20great.%20Now%20I%20need%20to%20be%20able%20to%20only%20count%20the%20ones%20that%20have%20dates%20in%20the%20table%20that%20match%20the%20date%20in%20a%20separate%20dropdown%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20incorporate%20this%20into%20my%20above%20formula%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20help%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlice%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1590505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590675%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Frequency%20formula%20that's%20dependant%20on%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590675%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760458%22%20target%3D%22_blank%22%3E%40Alice92%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20small%20sample%20workbook%20without%20sensitive%2Fproprietary%20information%20that%20illustrates%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1590849%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Frequency%20formula%20that's%20dependant%20on%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1590849%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760458%22%20target%3D%22_blank%22%3E%40Alice92%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20at%20the%20bottom%20of%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fcount-unique-text-values-with-criteria%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fformula%2Fcount-unique-text-values-with-criteria%3C%2FA%3E%26nbsp%3Bpost%20how%20to%20extend%20formula%20on%20two%20criteria.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

Could someone with more formula knowledge than myslef help me with the following please?

 

I'm using the formula {=SUM(IF(FREQUENCY(IF(ERRORS!D5:D1001<>"", MATCH(ERRORS!D5:D1001,ERRORS!D5:D1001,0)),ROW(ERRORS!D5:D1001)-ROW(ERRORS!D5)+1),1))} to count how many unique references I have in a table which works great. Now I need to be able to only count the ones that have dates in the table that match the date in a separate dropdown box.

 

Does anyone know how to incorporate this into my above formula?

 

Many thanks for your help in advance.

 

Alice

2 Replies

@Alice92 

Could you attach a small sample workbook without sensitive/proprietary information that illustrates the problem?

@Alice92 

Please check at the bottom of this https://exceljet.net/formula/count-unique-text-values-with-criteria post how to extend formula on two criteria.