arrays - Excel List Top Occuring Numbers -

i've search haven't found example finds top 3 occurring numbers in list. code text, top scoring or top 3 biggest values.

i have list of orders part numbers , prices occurred during year.

-a---------b---------c-------d-------e
60470 $58
60470 $58
89038 $60
31859 $37
60470 $58
29079 $78
35568 $40
82677 $92
69172 $37
31859 $37
89038 $60
31859 $37
31859 $37
60470 $58
31859 $37
60470 $58
31859 $37

column has part numbers , column b has prices. in column d list top 3 occurring part numbers column , then in column e sum total occurrences.

in example above, column d , e show following respectively:

31859 $222.00
60470 $290.00
89038 $120.00

i can't sort or add "helper" columns trying accomplish using array formula.

any assistance appreciated. thank you.

in d1, array formula**:

=index(a$1:a$17,match(large(if(frequency(a$1:a$17,a$1:a$17),frequency(a$1:a$17,a$1:a$17)+row(a$1:a$17)/10^6),rows($1:1)),frequency(a$1:a$17,a$1:a$17)+row(a$1:a$17)/10^6,0))

in e1:

=sumif(a$1:a$17,d1,b$1:b$17)

regards