Hey everyone, need help with this.

Column L contains the values I want to count the occurrences of. The list contains some values once, some multiple times. For example, the list contains the word "near" 32 times and the word "far" 1 time, BUT I only want to count 2 (once for each word)

Now I have seen the equation that does this for a set range:

=SUMPRODUCT(($A$1:$A$100<>"")/COUNTIF($A$1:$A$100,$A$1:$A$100&""))

And I understand what it does (Not really positive on how it actually works the calculation).

Anyways - Column J includes the date. So I want to make the above caluclation (counting each unique occurences only once in a list that includes duplicates) where it only looks at Column L cells that corresponding to Column J cells of the date in question.

Hopeuflly this makes sense, and thank you for any help in advance.