Formula for totaling selections

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.
 
J

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
 
M

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
 
D

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.
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top