Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
functions searching by date | Excel Discussion (Misc queries) | |||
Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
Searching a date | Excel Discussion (Misc queries) | |||
searching date | Excel Programming | |||
userform with date searching in worksheet | Excel Programming |