Excel.JPG

Red Box (P6)
Purple Box (Q6)
Green Box (P7:P18)
Pink Box (Q7:Q18)

Red Box Formula {=IFNA(INDEX(P7:P18,MATCH(MAX(Q7:Q18),Q7:Q18,0)),"")}

I would like to have purple to return the sum of the red box, summed up from the names in the green box using the values in the pink box, and returned to the purple box, ignoring blank cells

As pictured, green and red box are working.

but would like purple box to be $1350 (sum of the Beasley's listed)