title: Adding all the values below the current cell in Excel
body: <p>I am trying to display the total sum of all the numbers for a particular column. I want the sum to be displayed above the column as follows:</p>
  
  <pre><code>21   30
  A    B
  6    5
  6    10
  6    10
  3    5
  </code></pre>
  
  <p>I know I can sum the values and display it at the bottom of the column using <code>=SUM(A3:INDIRECT("D"&amp;ROW()-2))</code>, however I am not getting a way to display it at the top of the column.</p>
  
  <p>Please guide.</p>