Formula for totaling selections

[manogolf]

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.

 

[Jacob Skaria]

Try this formula in H2 and copy down as required....The formula will sum up
entries in row1 based 'x' in the corresponding cells

=SUMPRODUCT((A2:G2="x")*$A$1:$G$1)

If this post helps click Yes

 

[T. Valko]

Try this...

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

Copy down as needed.

 

[manogolf]

Thank you Jacob this worked perfectly and is truly appreciated.

Jerry

 

[manogolf]

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

 

[David Biddulph]

Do you have a #NAME? error in any of the cells in A1:G1?
If not, check you formula carefully. Did you try to retype it? Better to
copy from the newsgroup and paste into your formula bar.

 

[manogolf]

How about another?

Is there something that will query results of the returned formula array in
a new cell? Specifically which row has the greatest value and if two or more
rows match exactly display which rows those are.

Many thanks,
Jerry