View Single Post
  #3   Report Post  
Jack Schitt
 
Posts: n/a
Default

There may be a more efficient solution. I have not tried this over 60K
records, but in my example the population range is contained in C15:C36, the
lower bound date in C9 and upper bound in C10.

=SUMPRODUCT(--(C15:C36=C9),--(C15:C36<=C10))


"ejb030353" wrote in message
...
I have a date range that contains 60000 records, I need to count this

range
and return a value for the number found. i.e. number of records between
10/01/02 and 10/30/02