Formula for totaling selections
 

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.

Formula for totaling selections
 

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
---------------
Jacob Skaria


"manogolf" wrote:

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.

Formula for totaling selections
 

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.

Formula for totaling selections
 

Thank you Jacob this worked perfectly and is truly appreciated.

Jerry

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"manogolf" wrote:

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.

Formula for totaling selections
 

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.



.

Formula for totaling selections
 

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.
--
David Biddulph

"manogolf" wrote in message
...
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.



.

Formula for totaling selections
 

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

"manogolf" wrote:

Thank you Jacob this worked perfectly and is truly appreciated.

Jerry

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"manogolf" wrote:

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.