I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6.
I have them typed in one specific table called "Correspondence", with format like below:
<tbody>
</tbody>
I used Google Form to generate a spreadsheet of RAW data of respondents, where it will help me mark the RAW Scores, for each item on a separate column:
(An example)
<tbody>
</tbody>
The next thing I need to do is generate another table that sums up the Domain totals for each participant. So from the example above, I need to sum 1,3,5 as Domain A, 4 as Domain B and 2 & 6 as Domain C:
(An example)
<tbody>
</tbody>
The hardest thing is to find a proper method to kick start this process. Can anyone point me in the right direction? Either formulas or VBAs would be fine too. Thanks!
I have them typed in one specific table called "Correspondence", with format like below:
Question No. | Domain |
1 | A |
2 | C |
3 | A |
4 | B |
5 | A |
6 | C |
<tbody>
</tbody>
I used Google Form to generate a spreadsheet of RAW data of respondents, where it will help me mark the RAW Scores, for each item on a separate column:
(An example)
Submission ID | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 |
Participant 1 | 2 | 3 | 5 | 1 | 2 | 4 |
Participant 2 | 5 | 4 | 5 | 3 | 5 | 1 |
Participant 3 | 1 | 1 | 1 | 2 | 2 | 2 |
<tbody>
</tbody>
The next thing I need to do is generate another table that sums up the Domain totals for each participant. So from the example above, I need to sum 1,3,5 as Domain A, 4 as Domain B and 2 & 6 as Domain C:
(An example)
Domain A | Domain B | Domain C | |
Total score for Participant 1 | 9 | 1 | 7 |
<tbody>
</tbody>
The hardest thing is to find a proper method to kick start this process. Can anyone point me in the right direction? Either formulas or VBAs would be fine too. Thanks!