It's hard for me to tell what's going on without seeing sample data. Perhaps
you could list a sample of 9-10 rows from columns D and F and tell us your
expected results?
"Naomi" wrote:
Thanks Ken,
I've changed it to...
=sumproduct((F2:F100=DATEVALUE("1/1/2004")/(countif(D2:D100,D2:D100)+(D2:D100=""))
but I am getting a result that is a few short of what it should be. Any
ideas? I'm going crazy here!!
Thanks.
"Ken" wrote:
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!
|