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
|