title: Calculate Growth rate in Excel
body: <p>I have a last year sale and some currant year sale so I want calculate growth rate in F3 Cell number and I have used this formula <code>=SUM(D3:D4)/SUM(C3:C4)-1</code> to calculate the growth rate.</p>
  
  <p>Something like this:</p>
  
  <p><img src="https://i.stack.imgur.com/DcvcX.jpg" alt=""></p>
  
  <p>If I add some Sale in Current year then I drag down sum formula range in growth rate formula: </p>
  
  <p><img src="https://i.stack.imgur.com/lseus.jpg" alt="Please See Pic"></p>
  
  <p>I want automatic Calculate growth rate if I add new value in Current year and then automatic collect Sale from last year in same currant year sale and calculate growth rate.</p>
  
  <p><strong>Note:</strong> Growth rate will be Calculate day by day... </p>