Frequency sum depending on criteria not working when criteria is between dates

Hello, I actually figured this out whilst posting this so thought I'd stick it up anyway so people can see the solution in the future.

Here is the formula I'm working with:
{=SUM(IF(FREQUENCY(IF(EventbriteLeads!D2:D999999<>"",IF(AND(EventbriteLeads!E2:E999999>=Statistics!$B$15,EventbriteLeads!E2:E999999<=Statistics!$D$15), MATCH(EventbriteLeads!D2:D999999,EventbriteLeads!D2:D999999,0))),ROW(EventbriteLeads!D2:D999999)-ROW(EventbriteLeads!D2)+1),1))}

The objective is to count the number of distinct unique values (EventbriteLeads!D2:D999999) that are not blank (EventbriteLeads!D2:D999999<>"") and fall between two dates (IF(AND(EventbriteLeads!E2:E999999>=Statistics!$B$15,EventbriteLeads!E2:E999999<=Statistics!$D$15)......Statistics!$B$15 and $D$15 being the dates to search between.

I've used the same formula before except with only 1 criteria and it has worked. As soon as I add the AND statement in, returns nothing. The dates are correctly formatted and when I trade it for other possible AND statements it still doesn't work. Here is the one that has worked below:

=SUM(IF(FREQUENCY(IF(EventbriteLeads!D2:D999999<>"",IF(EventbriteLeads!K2:K999999="Yes", MATCH(EventbriteLeads!D2:D999999,EventbriteLeads!D2:D999999,0))),ROW(EventbriteLeads!D2:D999999)-ROW(EventbriteLeads!D2)+1),1))

THE FIX

{=SUM(IF(FREQUENCY(IF(EventbriteLeads!D2:D999999<>"",IF(EventbriteLeads!E2:E999999>=Statistics!$B$15, IF(EventbriteLeads!E2:E999999<=Statistics!$D$15, MATCH(EventbriteLeads!D2:D999999,EventbriteLeads!D2:D999999,0)))),ROW(EventbriteLeads!D2:D999999)-ROW(EventbriteLeads!D2)+1),1))}

They need to be separate IF statements

Or I think you can multiply them together
{=SUM(IF(FREQUENCY(IF(EventbriteLeads!D2:D999999<>"",IF((EventbriteLeads!E2:E999999>=Statistics!$B$15)*(EventbriteLeads!E2:E999999<=Statistics!$D$15), MATCH(EventbriteLeads!D2:D999999,EventbriteLeads!D2:D999999,0))),ROW(EventbriteLeads!D2:D999999)-ROW(EventbriteLeads!D2)+1),1))}

Yes! Thanks Davsth, makes the formula tidier.

My next objective is trying to figure out how to do similarly, but of the unique (EventbriteLeads!D2:D999999<>"",IF((EventbriteLeads!E2:E999999>=Statistics!$B$15)*(EventbriteLeads!E2:E999999<=Statistics!$D$15), see how many do not match in column EventbriteLeads!D2:D999999 with dates that are before Statistics!$B$15...

So that I can see within that date range, how many are absolutely fresh leads and not ones that have previously been encountered outside of the selected date range.