| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| product formula not totaling | Excel Worksheet Functions | |||
| Formula for totaling occurrences in a specified range | Excel Worksheet Functions | |||
| Excel "Sumproduct" Totaling formula? | Excel Worksheet Functions | |||
| Is there a multiple sheet totaling formula for XL 2003? | Excel Discussion (Misc queries) | |||
| Formula for totaling column | Excel Worksheet Functions | |||
Hybrid Mode
