Searching by date
 

Jim,

Assuming times in column A, amounts in B, try

=SUMPRODUCT((A1:A1000=TIME(13,0,0))*(A1:A1000<TIM E(14,0,0)*(B1:B1000<=3000)
))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jim K" wrote in message
...
I have data collect daily and need to report on this data. I need to find
1, the number of samples that occurred between 1-2am
2. the number of samples between 1-2am that were 3000
3. the number of samples between 1-2am that were <=3000 (obviously if I
can find 1-2 then I can determine 3)

I have to repeat this process for the entire 24 hour period.

Any help would be greatly appreciated, since this process it taking 45-60
minutes per day.

Thanks.

Jim