I have the following:
=COUNTIF(Sheet1!I3:I10,B4)
where B4 is a date and I3:I10 is a list of dates
to the above I want to introduce a method to uniquely count occurances in Sheet1 range A3:A10 but when there is also a match in range I3:I10 to B4
=COUNTIF(Sheet1!I3:I10,B4)
where B4 is a date and I3:I10 is a list of dates
to the above I want to introduce a method to uniquely count occurances in Sheet1 range A3:A10 but when there is also a match in range I3:I10 to B4