title: Excel - equivalent of Javascript reduce function?
body: <p>Is there an Excel equivalent of the Javascript <code>reduce</code> function? Essentially, I want to apply a function to each cell in a range, and then sum up each result.</p>
  
  <p>The reason I ask is because I have the following sheet:</p>
  
  <p><a href="https://i.stack.imgur.com/VRv2L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VRv2L.png" alt="excel screenshot"></a></p>
  
  <p>For each expense, I'm calculating the "change", i.e. the amount needed to round it up to the nearest pound. I'm then summing that at the bottom.</p>
  
  <p>I want to be able to do this without having the extra column and summing those values.</p>
  
  <p>Thanks.</p>