title: Dynamically setting the sum formula in excel
body: <p>I want to sum two cells values. Like i want sum of A1 and A2 in C1 then the formulla will be <code>=sum(A1,A2)</code>. but in this formulla row number fixed (i.e. 1 and 2). but I want that row number should be decided dynamically in excel. </p>
  
  <p>suppose i have integer values in cell range A1 to A100.Now i want sum of any two values beween A1 to A100. I am putting row number in B1 and B2 and writting this formula in C1 </p>
  
  <pre><code>=SUM(A&amp;B1,A&amp;B2)
  </code></pre>
  
  <p>so in above formulla Column A is fixed and i want to pick row number from other cell.</p>
  
  <p>for example if i enter the 5 in B1 and 10 in B2 the formulla should sum the A5 and A10 values. Similarly i can enter any value between 1- 100 in column B1 and B2.</p>
  
  <p>I want to do it directly in excel not in macro.</p>