I have a survey questionairre which asked for one or multiple answers.
Now I need to summarize the date and facing the belwo issue:
The question was asked to select one or more of the below options:
<tbody>
</tbody>
The final data received from the survey is in the form of below:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I need to summarise the total count on each of the 3 options for each region. I tried using countif, it did not work. I think I need to use Index formula s this is not simple vlookup case. Your assistance is appreciated.
Now I need to summarize the date and facing the belwo issue:
The question was asked to select one or more of the below options:
Options |
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | ||||
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody>
</tbody>
The final data received from the survey is in the form of below:
Row Labels | AMER | APAC |
Legislation | 1 | 1 |
Agency | 2 | 1 |
Others | 3 | - |
Legislation, Agency | 4 | 1 |
Agency,Others | 1 | 3 |
Legislation, Agency, Others | 1 | 5 |
Grand Total | 12 | 11 |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
I need to summarise the total count on each of the 3 options for each region. I tried using countif, it did not work. I think I need to use Index formula s this is not simple vlookup case. Your assistance is appreciated.