Calculate sum for a date range in Excel/Google Spreadsheets

I'd like to calculate the sum of multiple values for a range of overlapping dates. It should return the sum for a specific year and split the values that fall into more than one year proportionally.

Example:

╔══════════╦════════════╦════════════╗
║  Value   ║    From    ║     To     ║
╠══════════╬════════════╬════════════╣
║ 100,00 € ║ 01.01.2015 ║ 31.12.2015 ║
║ 150,00 € ║ 01.07.2015 ║ 31.06.2016 ║
║ 300,00 € ║ 01.01.2016 ║ 31.12.2016 ║
╚══════════╩════════════╩════════════╝

Expected result for year 2015: 175,00 €

Expected result for year 2016: 375,00 €

I did't find an efficient way using SUMIF() or SUMIFS(). Especially for splitting the result proportionally for overlapping dates.