title: how can I add the left cell and the upper cell using a formula in microsoft excel?
body: <p>I need to create a formula in microsoft excel to set the value of the cell which is the sum of the left cell and the upper cell?
  any idea how to do it?</p>
  
  <p>see below screenshot as an example, B2=A2 + B1, B3=A3 + B2, but I don't want to write a formula for each cell in column B one by one, any way to generate the formula automatically or is there any formula that works like "B1(or B2, B3...)=left() + upper()"</p>
  
  <p><a href="https://i.stack.imgur.com/NJ4q8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NJ4q8.jpg" alt=""></a></p>