I have a list names, dollar amount and %.
I need to calculate the weighted average % for each name, and then rank them
in order. Would I use the sumproduct formula?

X 100 5.6%
Y 200 4.0%
Z 300 4.4%
X 400 5.0%
Z 500 6.0%
Z 1000 6.65%
X 2000 6.4%