Hi All,

Thanks to XOR LX in a previous post I now have the below formula.

=SUM(IF(FREQUENCY(IF('Sheet 1'!$H$2:$H$5000=D6,IF(ISNUMBER(MATCH('Sheet 1'!$G$2:$G$5000,D8:D11,0)),MATCH("~"&'Sheet 1'!$C$2:$C$5000,'Sheet 1'!$C$2:$C$5000&"",0))),ROW('Sheet 1'!$C$2:$C$5000)-ROW('Sheet 1'!$C$2)+1),1))

It counts the number of unique data entries in Sheet 1 based on multiple criteria.

In the current sheet where the formula is though I would like to be able to include a date range so I can enter a start date (E1) and an end date (E2) and for the formula to still work but based on the date in sheet 1 column "I" I need the start date and end date to be included.

I know I need to include something like 'Sheet 1'!$I:$I,">="&$E$1,'Sheet 1'!$I:$I,"<="&$E$2 but I cannot get the formula to return with anything other than an error.

Thank you in advance.