G
Guest
Hi,
I have a unique count using a sumproduct formula like this...
=sumproduct((D2100<>")/(countif(D2100,D2100)+(D2100="")
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!
I have a unique count using a sumproduct formula like this...
=sumproduct((D2100<>")/(countif(D2100,D2100)+(D2100="")
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!