Need help with a formula that sums values between two dates matched to a name

Hi   I am hoping that someone can help me with a problem I am having. My Excel skills are for the most part self taught and I sometimes find multiple functions/nesting quite hard to get my head aro...