title: Sum minimum of corresponding column values
body: <p>I have two columns with numbers. I would like to calculate in a separate cell a sum. The sum will include the minimums of corresponding cells in these two columns.</p>
  
  <p>Example:</p>
  
  <pre><code>        A  |  B
         --------
  [1]     1  |  2
  [2]     4  |  3
  [3]     0  |  1
  [4]     5  |  5
  </code></pre>
  
  <p>I need a formula that would calculate in a cell the sum of 1 + 3 + 0 + 5 where </p>
  
  <pre><code>* 1 is the MIN(A1,B1), 
  * 3 is the MIN(A2,B2) 
  * 0 is the MIN(A3,B3)
  * 5 is the MIN(A4,B4)
  </code></pre>
  
  <p>Is that possible in a single formula (independent of #rows)? </p>
  
  <p>Working with LibreOffice Calc at the moment, but Excel solutions more than welcome.</p>