Multiple overlapping date ranges - sum a column if a date falls into any of these ranges

[14UR4]

Hi,

I've been trying to look around for anything similar, but I cant find anything at all

I have a list of ranged dates and a value next to them
then a date

for every date I want to check if it falls between any of the ranged dates and to sum every value where it does

This is an example of the structure:

Start	End	People
01/09/2017	20/10/2017	2
05/09/2017	30/11/2017	3

<tbody>
</tbody>

This is what I would expect to return:

02/09/2017	2
07/09/2017	5
21/10/2017	3

<tbody>
</tbody>

please can you help?

 

[mart37]

try: SUMIFS()