title: Adding a cell value to a formula within a COUNTIFS
body: <p>I have this formula working;</p>
  <pre><code>=COUNTIFS($G$14:G,&quot;Submitted&quot;,C14:C, &quot;=28&quot;)
  </code></pre>
  <p>The number 28 is given from cell B1 - how do I make 28 reference 'B1' &amp; work.</p>