Modify formula to add another criteria -- ISSUE

[ItalianPlatinum]

Hello - I have an existing formula that works as intended but I am having an issue trying to in-cooperate another criteria to check if the data matches to today's date. I have the date in Cell A3 but i get a null. I can provide XLBB to assist didn't know if there was a quick thing I am just excluding

Existing formula works
=SUMPRODUCT(('Ns'!$A$6:$A$30000<>"")/COUNTIFS('Ns'!$A$6:$A$30000,'Ns'!$A$6:$A$30000&""))

Modification for date criteria
=SUMPRODUCT(('Ns'!$A$6:$A$30000<>"")/COUNTIFS('Ns'!$A$6:$A$30000,'Ns'!$A$6:$A$30000&"",'Ns'!$B$6:$B$30000,A3))
Result: #DIV/0!

B6:B30000 will have the date. A3 = today()

 

[ItalianPlatinum]

here is the XLBB. Anyone able to assist?

test2.xlsm
	A	B	C
1		9/30/2020
2
3	Total	19
4	DESIRED	16
5
6	Type	Submission Date
7	AAA	9/30/2020
8	BBB	9/30/2020
9	CCC	9/30/2020
10	DDD	9/30/2020
11	EEE	9/30/2020
12	FFF	9/30/2020
13	GGG	9/30/2020
14	HHH	9/30/2020
15	III	9/30/2020
16	JJJ	9/30/2020
17	KKK	9/30/2020
18	LLL	9/30/2020
19	MMM	9/30/2020
20	NNN	9/30/2020
21	OOO	9/30/2020
22	PPP	9/30/2020
23	ZZZ	9/29/2020	Not current Day
24	XXX	9/29/2020	Not current Day
25	YYY	9/29/2020	Not current Day
26	OOO	9/30/2020	Duplicate
27	OOO	9/30/2020	Duplicate
28	OOO	9/30/2020	Duplicate
29	PPP	9/30/2020	Duplicate
Ns

Cell Formulas
Range	Formula
B1	B1	=TODAY()
B3	B3	=SUMPRODUCT((Ns!$A$7:$A$3001<>"")/COUNTIFS(Ns!$A$7:$A$3001,Ns!$A$7:$A$3001&""))