title: Excel - Multiply rows that contain a true checkbox by a fixed value
body: <p>I'm trying to multiply any rows that have a checked checkbox with a flat day rate value and output the result to a total cell.</p>
  
  <p>I've tried the following SUM on the total column without much luck:</p>
  
  <pre><code>=SUMPRODUCT(($B$6:$B$37=TRUE)*($D$3))
  </code></pre>
  
  <p>In pseudo it would be something like:</p>
  
  <blockquote>
    <p>Find within these cells (B6-B37) the number of rows that have a true
    checkbox and multiply that value by the day rate value in D3 and
    output the result in I11.</p>
  </blockquote>
  
  <p>So for illustrative purposes, the example below would have a total of 10 because 4 checkboxes are checked and 4 x 2.50 = 10.</p>
  
  <p><img src="https://i.stack.imgur.com/LVCYv.png" alt="enter image description here"></p>
  
  <p>I'm sure it's something simple but I rarely use excel.</p>
  
  <p>Many thanks for your time.</p>
  
  <p>Chris</p>