I want will be as specific as possible





I have the red box (P6) returning most frequent value of P7:P18 using

=IFNA(INDEX(P7:P18,MATCH(MAX(Q7:Q18),Q7:Q18,0)),"" )

I would like the Purple box (Q6) to return the SUM of all the red box (P6) names into the purple box using the amounts listed in the pink box.

example Beasley's appears twice. once for $150 and once for $1200

I want the purple box to be $1350 and then I can use the =Q6 in the pink box.