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