# Sum values in overlapping date ranges

#### mattrogers

##### New Member
We have a list of meetings including start and end times as well as the number of attendees that participated in the meeting. We would like to find which meetings have overlapping times then sum the number of attendees for each of the meetings that overlapped.

For example:

 Start End Attendees Overlap Count 1 10/15/2012 06:29:51 10/15/2012 07:19:53 2 0 2 10/15/2012 06:59:56 10/15/2012 07:15:27 1 3 3 10/15/2012 07:21:31 10/15/2012 09:06:55 1 0 4 10/15/2012 07:31:40 10/15/2012 08:00:21 5 0 5 10/15/2012 10:00:52 10/15/2012 11:09:31 2 0 6 10/15/2012 11:00:26 10/15/2012 12:10:58 3 5 7 10/15/2012 11:51:00 10/15/2012 13:33:58 2 5 8 10/15/2012 13:33:03 10/15/2012 14:30:19 2 4 9 10/15/2012 14:01:21 10/15/2012 16:23:36 3 5 10 10/16/2012 06:59:33 10/16/2012 08:07:58 3 0 11 10/16/2012 07:29:40 10/16/2012 08:21:12 3 6 12 10/16/2012 08:04:36 10/16/2012 08:42:02 3 9 13 10/16/2012 11:31:25 10/16/2012 12:58:59 5 0 14 10/17/2012 08:02:31 10/17/2012 08:13:41 2 0 15 10/17/2012 09:01:01 10/17/2012 09:42:24 3 0 16 10/17/2012 09:56:36 10/17/2012 10:16:27 2 0 17 10/17/2012 11:06:40 10/17/2012 11:56:40 3 0

<tbody>
</tbody>

As you can see there are several meetings that overlap with each other, but some of them overlap with more than just one other meeting. What we would like to be able to do is provide of number of attendees in the Overlap Count column of how many simultaneous attendees are in a meeting.

If you should have any questions I'll be more than happy to answer them.

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Replies
2
Views
114
Replies
7
Views
122
Replies
1
Views
477
Replies
18
Views
332
Replies
1
Views
203

1,219,905
Messages
6,150,907
Members
450,991
Latest member
ExcelDoer

### 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.

### Which adblocker are you using?

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

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