need help with sumproduct

[joe2324]

On the attached spreadsheet, I'm trying to use a formula to sum the top 2 values for each Name.
I know how to sum the top 2 values using an array. This formula will sum the top 2 values within a range, but i'm trying to sum the top 2 per name.
So, on the spreadsheet attached, the answer should be 477 to sum the top 2 for Joe. I have a feeling this one is going to be complicated.

=SUM(LARGE(TheRange,ROW(INDIRECT ("1:2"))))

[Tony Valko]

Try this array formula**:

=SUM(LARGE(IF(A2:A11=F2,B2:B11),{1,2}))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Note that in the sample file, cell F2 contains a trailing space character: bob[space]

[joe2324]

perfect! thank you for your help!

[Tony Valko]

You're welcome. Thanks for the feedback!