Home/ Questions/Q 13715
Next
Answered
computing
  • 1
Asked: 2021-12-13T14:42:43+00:00 In:

Solved Dropdown Yes/No = 1/0

  • 1

I know how to create a dropdown list but I want to know how to create a rule on each option of the dropdown. Eg, it will be a yes/no dropdown, if I choose ‘yes’ it should be = to ‘1’ and if I choose ‘no’ it should be = to ‘0’. Please help.

Share

    1 Answer

    1. Best Answer
      Instead of a SUM() function,
      you can use the COUNTIF() function:

           A
1)  Yes
2)   No
3)  Yes
4)  Yes
5)   No

      In cell A6 put the formula: =COUNTIF(A1:A5,”Yes”)

      You should get the value 3

      Would that work for you?

      MIKE

      http://www.skeptic.com/

      • 0