Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rbrooks
 
Posts: n/a
Default 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

  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofilter on date fields should refelct the underlying data (rat. mrpb Excel Discussion (Misc queries) 5 January 18th 05 04:11 PM
Date Overdue function, Macro, or VBS Galsaba Excel Discussion (Misc queries) 5 January 14th 05 01:26 AM
Today() or Date() function help julisimo Excel Discussion (Misc queries) 8 January 3rd 05 05:19 PM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 3rd 04 12:23 AM
Formatting date fields after export Raymond Excel Discussion (Misc queries) 2 December 1st 04 01:04 AM


All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"