Hi Naomi,
When you reference dates in formulas like this, the syntax is:

F2:F100=DATEVALUE("5/5/2003")

HTH

"Naomi" wrote:

Hi,
I have a unique count using a sumproduct formula like this...

=sumproduct((D2:D100<")/(countif(D2:D100,D2:D100)+(D2:D100="")

which seems to work ok. The problem is I then want to add another criteria
saying only count uniques where the date in column F = "01/01/05". Nothing
I've tried seems to work.

Thanks in advance!