Use this formula to get unique names list

Enter in E2 and copy down

=IFERROR(INDEX($A$2:$A$5,MATCH(0,INDEX(COUNTIF(E$1:E1,$A$2:$A$5),,),)),"")

enter formula in F2 and and pull it to the right and then down

=SUMIFS(INDEX($B$2:$C$5,0,MATCH(F$1,$B$1:$C$1,0)),$A$2:$A$5,$E2)

Data Range
A
B
C
D
E
F
G
1
Names
Apples
Oranges
Uniqe names
Apples
Oranges
2
Ken
2
5
Ken
2
5
3
James
5
8
James
10
9
4
James
5
1
John
3
3
5
John
3
3