Unique Values with Dates and additional criteria

[Greenies08]

Hi, could someone please help me develop this formula to include another column criteria...

=SUMPRODUCT(--(UNIQUE(FILTER(Register!$F$2:$F$513,TEXT(Register!$B$2:$B$513,"yyyy-mm")=B$4))<>""))

Column F is the unique ranges
Column B is the dates

I want to add Column D which refers to individuals names

So I want to calculate how many unique entries under column F for the specified criterion of dates (column B) and names of people (column D)

Thank you so much in advance

 

[Fluff]

Are the names in col D on both sheets?

 

[Greenies08]

Hi, yes all the columns are on the one sheet called 'Register' - so I want to find the count of the unique entries in column F if Column B and Column D are matching the cells that have a date (B4 in this case) and persons name in (which will be cell B3)

 

[Fluff]

Ok, how about

=ROWS(UNIQUE(FILTER(Register!$F$2:$F$513,(TEXT(Register!$B$2:$B$513,"yyyy-mm")=B$4)*(Register!$F$2:$F$513<>"")*(Register!$D$2:$D$513=B$3))))

 

[Greenies08]

OMG you are an angel and a genius - thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.