title: Excel: How to add nested function inside sum?
body: <p>If this is my workbook:</p>
  
  <pre><code>A   B
  1   6
  2   5
  3   4
  </code></pre>
  
  <p>I want to calculate (1-6)+(2-5)+(3-4) = -9. How can I sum the difference of two columns without creating a new column to store the differences first? I want something like =sum(A1:A3-B1:B3), but it's not correct. So what else might work?</p>