Hello,

I would like to create a function similar to SUMIF(LARGE). Unfortunately large does not work within the sumif function. Can someone advise me how to select the 2 largest values meeting the criteria "A" and add them together? I have been able to come close with a pivot table but ultimately it does not work correctly when "A" has the same value multiple times in the table.

A 1
B 5
C 3
D 4
E 9
A 2
B 3
F 2
G 5
A 1
B 6

Any help is appreciated.

Thanks!