Thanks for helping out. This returned a #NAME? error when trying to use.
Perhaps I did not mess with it long enough to make it work.

Thanks,
Jerry

"T. Valko" wrote:

Try this...

=SUMIF(A2:G2,"X",A$1:G$1)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"manogolf" wrote in message
...
A mysql database dumps user generated form selections into an excel
spreadsheet. The form asks the user to select three choices from those
available. I would like to compare the selections the user made against
actual results. I'll try to illustrate.

A B C D E F G
1 18 25 0 0 92 7 67
2 X X X
3 X X
X
4 X X
X
5 X X X
6 X X X


Row 1 is the points awarded for selecting that column. Rows 2-6 represent
user selections. What is needed is a way to total users accumulated points
based on their selections. So user 4 accumulated the most points 0+92+67.

In truth there are around 100 users making selections from a list of
130+-,
but hopefully the illustration is representative.



.