Sum function on multiple date fields
 

Hi,

I have a worksheet with start and end times of reports. I'm trying to
identify the maximum number of reports running at a given time (column
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 the
data looks like:

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

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

Thanks,
Russ


--
rbrooks
------------------------------------------------------------------------
rbrooks's Profile: http://www.excelforum.com/member.php...o&userid=15851
View this thread: http://www.excelforum.com/showthread...hreadid=273419

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

--
Regards
Frank Kabel
Frankfurt, Germany

"rbrooks" schrieb im Newsbeitrag
...

Hi,

I have a worksheet with start and end times of reports. I'm trying
to
identify the maximum number of reports running at a given time
(column
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
the
data looks like:

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

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

Thanks,
Russ


--
rbrooks
---------------------------------------------------------------------
---
rbrooks's Profile:
http://www.excelforum.com/member.php...o&userid=15851
View this thread:
http://www.excelforum.com/showthread...hreadid=273419