How to sum range of cells with the same formulas in excel <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>