How to calculate count from selected option

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)

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

1 Like

@Kal_Lam Thank you for reply!

Thanks!

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)

@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?

@Kal_Lam Yes.

@Kal_Lam Yes, correct. Is it possible here?