Countifs and sumifs using Name Range

First have you tried cleaning your data (column A) and lookup references in G3:G16? Some of them have trailing space(s) while others do not. Check out "Jonathan" for example.

I haven't checked the rest......but where there is one....

After you do try this formula in H3 and fill down.

Formula:

=SUMPRODUCT(COUNTIFS($A:$A,G3,$D:$D,Docs))

Then try this in I3 and fill down.

Formula:

=SUMPRODUCT(SUMIFS($C:$C,$D:$D,Docs,$A:$A,$G3))