I have red box returning the most frequent text of the green box.

I would like the purple box to return the sum of the name in the red box.

example, I want Beasley's (red box) totals in the pink box to return in the purple box. have $1,350 in the purple box

thanks