title: Excel 2013 VBA user forms add countIf calculation
body: <p>I am trying to build a score card. On the form I have a few questions and comboboxes with <code>yes</code>, <code>no</code>, <code>N/A</code> and results.</p>
  
  <p>What I am trying to do is create a result that works like this:</p>
  
  <pre><code>If ComboBox1=yes, ComboBox2=no, ComboBox3=yes and ComboBox4=N/A
  </code></pre>
  
  <p>then the calculation will be as such:</p>
  
  <pre><code>evaluate.Lable1 = ((countif(Range(ComboBox1,ComboBox2,ComboBox3,ComboBox4),="yes")/(Counta(Range(ComboBox1,ComboBox2,ComboBox3,ComboBox4))-((countif(Range(ComboBox1,ComboBox2,ComboBox3,ComboBox4),="N/A")
  </code></pre>