Sum values only once when value listed more than once

[Nebula2121]

	A	B	C
1	Name	Value	Result
2	Apple	5	7
3	Broccoli	10	12
4	Broccoli	1	0
5	Apple	2	0
6	Broccoli	1	0
7	Pear	5	0

<tbody>
</tbody>

How do I set up an excel formula for the desired result in Column C? I would like the sum of value for each name to show up once and only have the largest 2 result present. I can do this easily with a pivot, but can't figure out the formula. Thanks!

 

[Eric W]

Try:

	A	B	C
1	Name	Value	Result
2	Apple	5	7
3	Broccoli	10	12
4	Broccoli	1
5	Apple	2
6	Broccoli	1
7	Pear	5

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet6​

Array Formulas Cell Formula C2 {=IF(COUNTIF($A$1:$A1,A2)>0,"",IF(SUMIF($A$2:$A$7,A2,$B$2:$B$7)>=LARGE(SUMIF($A$2:$A$7,$A$2:$A$7,$B$2:$B$7)*IF(MATCH($A$2:$A$7,$A$2:$A$7,0)=ROW($A$2:$A$7)-ROW($A$2)+1,1,0),2),SUMIF($A$2:$A$7,A2,$B$2:$B$7),""))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[Nebula2121]

How would I adjust the formula for the top 4 results? Your help is much appreciated.

 

[Nebula2121]

Woohoo. I figured it out. Thanks again for the help!

 

[Eric W]

Glad to help!