Sum function on multiple date fields

[rbrooks]

Hi,

I have a worksheet with start and end times of reports. I'm trying t
identify the maximum number of reports running at a given time (colum
A) by doing a {=sum((c:c<=a2)*(d:d>=a2)))}
Column A has a list of times, increasing by 1 second. A sample of th
data looks like:

Time Program StartDate EndDate
10/25/2004 0:00:00 SAPCONNECT 10/25/2004 00:00:01 10/25/200
00:00:01
10/25/2004 0:00:01 ZLICAT001_RC69 10/25/2004 00:00:19 10/25/200
00:00:22
10/25/2004 0:00:02 ZVICFS001_LOCK 10/25/2004 00:00:50 10/25/200
00:00:51
10/25/2004 0:00:03 ZVIDET001_LOCK 10/25/2004 00:00:50 10/25/200
00:00:51
10/25/2004 0:00:04 FTP_ZZGCIA007 10/25/2004 00:00:50 10/25/200
00:00:52

I don't think I'm even close to getting this to work. Does anyone hav
any suggestions?

Thanks,
Rus

 

[Frank Kabel]

Hi
not quite sure but try:
=SUMPRODUCT(--($C$1:$C$100<=A2),--($D$1:$D$100>=A2))