title: How to sum range of cells with the same formulas in excel
body: <p>I got a range of cells that use the same formula:</p>
  
  <pre><code>=A1*IF(B1="Yes",1,0)
  =A2*IF(B2="Yes",1,0)
  ...
  </code></pre>
  
  <p>I would like to have one cell with the sum of all cells in a range of <code>A1..A10</code></p>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>