At bottom of table (say row 101) calculate the sum for each option
=SUM(B2:B100)
and copy across to all the other options. (should go to column U)
In row 202
=RANK(B101,$B$101:$U$101,1)
and copy across

Now, to generate your list of options in order of preference (this assumes
that people marked a 1 for option they wanted most, 2 for 2nd favorite, etc.)

=INDEX($B$1:$D$1,1,MATCH(ROW(A1),$B$6:$D$6,0))

Copy this down as needed
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nadine" wrote:

Look for a help creating a formula, if it possible, to find out the overall
rating results
example - first row going across lists all the options provided - there are
20 options and people rated the options in order of preference
first column going down lists the poeples names
for each name - going across have entered the rating given for an option 1
thru 20.

Is there a way to find out the overall rating of an option.

What I want to do in the end is build a list of the options and list them in
the order of the preference, based on the ratings.
i.e. if the 3rd option was the first choice by everyone then would put it
first on the new list.

Thanks for any help
Nadine