Concurrent Calls in Excel

sbcccc

New Member
Joined
Aug 14, 2018
Messages
2
[FONT=&quot]I am trying to find a formula to find the number of concurrent calls at one time. My columns contain phone provider, outbound number, inbound number, start date and time (one cell), duration of call, and end date and time (one cell) from A to H in the order they are listed. In this stage of the project, inbound and outbound numbers are not important and aren't necessary to include, nor are the phone providers or the durations. Some of the calls last several days, so that will have to be taken into account. There are almost 20,000 rows in the sheet, so it would be ridiculous to do it manually. I am essentially just looking for how many phone calls are active at one time. If there is a formula that can help me do that, that would be great. I have already tried many =COUNTIFS and =SUMPRODUCT formulas, but they are not giving correct results. This project is due fairly soon, so any answer could be helpful. [/FONT]

[FONT=&quot]Thanks![/FONT]
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
A​
[/td][td="bgcolor:#C0C0C0"]
B​
[/td][td="bgcolor:#C0C0C0"]
C​
[/td][td="bgcolor:#C0C0C0"]
D​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
1​
[/td][td="bgcolor:#F3F3F3"]
Start
[/td][td="bgcolor:#F3F3F3"]
End
[/td][td="bgcolor:#F3F3F3"]
#Active
[/td][td="bgcolor:#F3F3F3"]
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
2​
[/td][td]
14 Aug 2018 11:00:29​
[/td][td]
14 Aug 2018 11:01:31​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td="bgcolor:#CCFFCC"]C2: =COUNTIFS(A$1:A2, "<" & B2, B$1:B2, ">" & A2)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td]
14 Aug 2018 11:01:07​
[/td][td]
14 Aug 2018 11:03:22​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td]
14 Aug 2018 11:01:47​
[/td][td]
14 Aug 2018 11:03:21​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td]
14 Aug 2018 11:02:25​
[/td][td]
14 Aug 2018 11:04:19​
[/td][td="bgcolor:#CCFFCC"]
3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td]
14 Aug 2018 11:03:35​
[/td][td]
14 Aug 2018 11:05:14​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td]
14 Aug 2018 11:03:36​
[/td][td]
14 Aug 2018 11:04:06​
[/td][td="bgcolor:#CCFFCC"]
3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td]
14 Aug 2018 11:04:16​
[/td][td]
14 Aug 2018 11:04:19​
[/td][td="bgcolor:#CCFFCC"]
3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td]
14 Aug 2018 11:04:50​
[/td][td]
14 Aug 2018 11:06:28​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td]
14 Aug 2018 11:05:53​
[/td][td]
14 Aug 2018 11:06:09​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td]
14 Aug 2018 11:07:21​
[/td][td]
14 Aug 2018 11:07:23​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
12​
[/td][td]
14 Aug 2018 11:08:39​
[/td][td]
14 Aug 2018 11:09:29​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
13​
[/td][td]
14 Aug 2018 11:09:47​
[/td][td]
14 Aug 2018 11:11:30​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
14​
[/td][td]
14 Aug 2018 11:10:39​
[/td][td]
14 Aug 2018 11:12:07​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
15​
[/td][td]
14 Aug 2018 11:10:46​
[/td][td]
14 Aug 2018 11:11:27​
[/td][td="bgcolor:#CCFFCC"]
3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
16​
[/td][td]
14 Aug 2018 11:11:26​
[/td][td]
14 Aug 2018 11:12:59​
[/td][td="bgcolor:#CCFFCC"]
4​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
17​
[/td][td]
14 Aug 2018 11:13:00​
[/td][td]
14 Aug 2018 11:15:14​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
18​
[/td][td]
14 Aug 2018 11:14:28​
[/td][td]
14 Aug 2018 11:16:37​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
19​
[/td][td]
14 Aug 2018 11:15:33​
[/td][td]
14 Aug 2018 11:16:22​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
20​
[/td][td]
14 Aug 2018 11:15:40​
[/td][td]
14 Aug 2018 11:16:42​
[/td][td="bgcolor:#CCFFCC"]
3​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
21​
[/td][td]
14 Aug 2018 11:17:11​
[/td][td]
14 Aug 2018 11:19:19​
[/td][td="bgcolor:#CCFFCC"]
1​
[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
22​
[/td][td]
14 Aug 2018 11:18:09​
[/td][td]
14 Aug 2018 11:19:48​
[/td][td="bgcolor:#CCFFCC"]
2​
[/td][td][/td][/tr]
[/table]
 
Upvote 0
Thank you for replying-- unfortunately this did not work for me, it resulted in 0 all the way down the column.
 
Upvote 0
Maybe you didn't copy correctly, or adjust to match your ranges?
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,632
Latest member
jladair

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top