sumproduct
Just add a new column to multiply the weight by the percentage, and then
rank that new column.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Confused" wrote in message
...
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%
|