matching last 2 columns with date

Have alook at the attached, i used Max(if... to determin the latest date for each name, then sumifs to find the % complete for that combo.

the max if formula is an array formula, so needs to be confimred with Ctrl+Shift+Enter and is:
=MAX(IF(A2:A7=F2,B2:B7,0))

the other is a standard sumifs
=SUMIFS(C:C,A:A,F2,B:B,G2)