I have an aggregate report due to my CEO (its late)

I am working in 2 different worksheets. 1 is detailed and 1 is a summary. Cells include; Name, total A, total B. My detailed worksheet has multiple listings of the same name with different totals. I am trying to take the sum total A and total B for each name and put this into the summary worksheet for each matched name. (not sure if I can do a screen shot here and/or provided enough information).

I created a pivot table to sum both totals from the detailed worksheet. I just can get the sum totals to my summary worksheet.

I have tried DSUM, SUMPRODUCT, COUNTIF, SUMIF.

Here is the formula I am currently trying:
.=SUMIF(GrantsList!A7:A460,"Ahmed",GrantsList!C7:C460)

Can anyone help?