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:

[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl64, width: 64"]Start[/TD]
[TD="class: xl64, width: 64"]End[/TD]
[TD="class: xl64, width: 64"]People[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]01/09/2017[/TD]
[TD="class: xl65, align: right"]20/10/2017[/TD]
[TD="class: xl64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, align: right"]05/09/2017[/TD]
[TD="class: xl65, align: right"]30/11/2017[/TD]
[TD="class: xl64, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]

This is what I would expect to return:
[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl67, width: 64, align: right"]02/09/2017[/TD]
[TD="class: xl66, width: 64, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]07/09/2017[/TD]
[TD="class: xl66, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl67, align: right"]21/10/2017[/TD]
[TD="class: xl66, align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]


please can you help?

 

[mart37]

try: SUMIFS()