Count the number of unique values in a month

[mattyblueice]

Hi, I am trying to find a formula that will count the number of unique site visits during a month. My mock database is below and I have been trying to use Countif with Unique, but I can't find an example online. Any suggestions would be appreciated. Thanks so much

 

[Fluff]

How about

=iferror(rows(unique(filter(c5:c100,d5:d100=g4))),0)

 

[mattyblueice]

That worked like a charm Fluff. Wish I was smart as you! Happy Holidays to you!

 

[Fluff]

You're welcome & thanks for the feedback.