Sumif based on date range in another table

Hi guys   I have got two tables linked via unique ID (ref). I am trying to pull the data through for each id which has own start and end date. There is another table holds month by month data. Is ...