MAXA & SUMIFS data range problem

[rwabennett]

Help requested to apply a date range to MAXA function. The problem is difficult to describe but I have attached a worksheet which should illustrate the problem. This is my first post, so please bear with me !

My aim is to search an open ended list and display a maximum value per individual within a specified date range (or a specific year). I have nearly solved the problem, but......

This first expression lists the max value (per individual) in the open-end list but I need to specify a date range and/or a specific year

{=MAXA(--(($B$2:$B$24=$G6)*$C$2:$C$24))}

This SUM function works using a date range per individual within a date range

=SUMIFS($D$2:$D$24,$B$2:$B$24,$G14,$A$2:$A$24,">"&$G$13,$A$2:$A$24,"<="&$H$13)

What I need is cross between the two !

Appologies, I know the cell references are not meaningful looked at in isolation, please see the attached sheet.

Thanks in advance

Richard