Remember Me?

#1
October 28th 04, 09:50 PM
 rbrooks Posts: n/a
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

#2
October 28th 04, 09:56 PM
 Frank Kabel Posts: n/a

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post mrpb Excel Discussion (Misc queries) 5 January 18th 05 03:11 PM Galsaba Excel Discussion (Misc queries) 5 January 14th 05 12:26 AM julisimo Excel Discussion (Misc queries) 8 January 3rd 05 04:19 PM pfe Excel Discussion (Misc queries) 2 December 2nd 04 11:23 PM Raymond Excel Discussion (Misc queries) 2 December 1st 04 12:04 AM

All times are GMT +1. The time now is 02:55 AM.