Depending on exactly why/howoften you need this data, you might just do a
Autofilter on Columns A ad B, and then sum C.........

Vaya con Dios,
Chuck, CABGx3



"jc" wrote:

Example...

Data is in 3 columns. I have a drop-down list containing distinct
values from col 1 (A,B,C,D). On selection of a value from this list I
want find to find it's 2 highest values in column 2, and sum the
corresponding column 3 values. I'm guesssing this will be some horrible
kind of INDEX, MATCH, LARGE type array formula.


A,12,1
B,28,2
C,34,3
D,46,4
A,52,5
D,66,6
C,77,7
A,83,8
B,95,9
D,51,10
C,42,11