title: Excel function to check for check box marked?
body: <p>I'm new to working in excel. Basically I'm trying to print some statements in a result box if all relevant check boxes are checked in a given column. Its laid out like the following for a given column:</p>
  
  <pre><code>A                     B
  Number of checkboxes: 8
  Overall status:       ["Pass" if all 8 checkboxes are checked below, else "fail"]
  Checkboxs:            checkbox 1 []
                        checkbox 2 []
                         ...
                        checkbox 8 [X]
  </code></pre>
  
  <p>I'm using Form Control check boxes, How can i refer to each of the 8 checkboxes in cell b2?  </p>