title: SUM the result of dividing two cells (SUMPRODUCT but division instead)
body: <p>I'm looking to do the equivalent of <code>SUMPRODUCT</code> but with division. Is there a way to add the results from dividing two arrays?</p>
  
  <p>Example: Column A has the "life" of an asset in years <code>(10, 20, 10)</code>. Column B has the Value of the asset <code>(10,000, 20,000, 20,000)</code>. I want to add the result of <code>(10,000/10) + (20,000/20) + (20,000/10) = 4,000</code>, but for the formula to be dynamic as I add rows with life and value.</p>
  
  <p>Thanks in advance.</p>