How to calculate count from selected option

[sudarshan]

Hello,
How to count the selected option number from the dropdown type question.
Example below image I have selected 3 option, I need 3 count.

Project:
a66JvzJWvB948NgWFXvyxc.xlsx (6.6 KB)

[Kal_Lam]

@sudarshan, you could do it as outlined in the post discussed previously:

Counting the not selected choices

Hi @joelkosianza, You could do the same as outlined in the image below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: [Image 3] Reference xlsform: Selection Counts.xls (27.5 KB) Have a great day!

[sudarshan]

@Kal_Lam Thank you for reply!

Thanks!

[sudarshan]

Hi,

1. How to count if both Coconut and Watermelon are selected, the count should be 1'. If anyone is selected (from CoconutorWatermelon) , then it should be 1`.

2. also Kiwi should not count even if selected.

Count output should be 2.
Apple is 1 + Coconut/watermelon is 1 + Kiwi is 0 = 2

Selection Counts.xls (27.5 KB)

[Kal_Lam]

@sudarshan, did you mean that if both Coconut and Watermelon are selected, the count should be 1? If anyone is selected, then it should be 1. Did I get that correct?

[sudarshan]

@Kal_Lam Yes.

[sudarshan]

@Kal_Lam Yes, correct. Is it possible here?