Determining Number of Concurrent Conference Calls Based on Start and End Times/Dates

[SpaceMadness]

Hi everyone,

I have a list of about 3000 teleconference call start and end times, and I need to calculate how many concurrent calls took place throughout the month. The data is organized by location, start date/time and end date/time like so: Concurrent Calls Sample.xlsx. I'm a fairly decent overall Excel user but am apparently not familiar enough with VBA or the type of formula that would work best here. I am open to using any method that will get me the data I need for this one-time customer ask.

I'm using Excel 2013 and have tried a couple of suggestions that I Googled, but most of them returned the same incorrect result. Is it possible to determine the number of concurrent calls with the data in its current format? Thank you for any assistance you can provide!

[lcartwright]

412219d1438899129-determining-number-of-concurrent-conference-calls-based-on-start-and-end-time.xlsx

I had an issue with you spreadsheet until I figured out you had auto calculate turned off, however using this formula should help:

=SUMPRODUCT(--($B$2:$B$13<=B2),--($C$2:$C$13>=B2))

[kvsrinivasamurthy]

Try this
E2=01-06-2015
F2=01-07-2015
G2=SUMPRODUCT(--($B$2:$B$13<$F2),--($C$2:$C$13>$E2))

[SpaceMadness]

Ahhhh...I didn't even think of auto-calc being turned off, but I did recently upgrade to Excel 2013 and maybe it defaulted to manual. That explains a lot. The formula works perfectly; thank you for your help!