title: Sumproduct division in google spreadsheets
body: <p>When working in excel, to find the sum of the quotients of corresponding numbers in two sets, you use a function as follows:</p>
  
  <p>=SUMPRODUCT(A1:A5 / B1:B5)</p>
  
  <p>In google spreadsheets though, although the sumproduct function exists, it cannot do division like this.</p>
  
  <p>In case you are not familiar with excel, this is basically what I want to achieve:</p>
  
  <p>Column A: 5, 7, 3, 9, 4
  Column B: 3, 2, 9, 8, 4</p>
  
  <p>Result: (5 / 3) + (7 / 2) + (3 / 9) + (9 / 8) + (4 / 4)</p>
  
  <p>Please note I am using google spreadsheets and not excel!</p>