Formula for totaling selections

  • Thread starter Thread starter manogolf
  • Start date Start date
M

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.
 
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
 
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
 
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.
 
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
 
Back
Top