Hi Bob.
Basically I have named the date range as "Date" and the name range as
"Names". I have used another sheet for my formulas and have 2010/01/01 in
cell B2 and 2010/01/08 in cell B3 (which I had to use for sumproducts).
I tried your formula but it comes back as FALSE?
Surely if I can sumproduct between dates there must be a way to
countproduct? I don't need to eliminate any duplicates.
I am a new excel learner.
Your assistance is much appreciated.
Thanks,
Vicki

"Bob Bridges" wrote:

Here's how I'd do it, Vicki: Create a helper column, say in N,
"=AND(A2=DATE(2010,1,1),A2<=DATE(2010,1,8))". Then use =COUNTIF(N:N,TRUE)
and it'll count how many rows have dates in that range.

Do you need to eliminate duplicate names?

--- "Vicki Leibowitz" wrote:
I have dates in column A and names in column B. I need to count how many
names there are say between 1 Jan & 8 Jan. Help before my brain explodes....