ExcelOrama
New Member
- Joined
- Nov 11, 2017
- Messages
- 4
Howdy...Looking for tips to achieve multiple sums.
I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet.
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>
I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet.
<tbody> </tbody> | ||||||||||||||||||||||||
When users select each of the criterion in a separate sheet as provided by drop-down lists, I need to tally up the values as affiliated with each criterion. For instance, when user selects Txt 3 for criterion 1 along with Txt 2 for criterion 2 from the drop-downs, total value should add up to 5. Any helpful suggestions are appreciated.
<tbody> </tbody> | ||||||||||||||||||||||||
<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>