title: Skip blank cells until value added in Google Sheets
body: <p>I've created a budget sheet that includes a running balance in column E. </p>
  
  <p>The problem that I've run into is my formula <code>=IF(C140="","",(SUM($E139,C140)))</code> works down the line after E140 (first day of the month that I started to implement this) until there is a blank. At the blank, the formula breaks for me. Now because this is a projected running total, it's preferred to have the blank spaces to allow for the days of the month. </p>
  
  <p>I've tried a couple different ways to get the isblank or lookup formulas to work but I realize this is beyond my excel and google sheets knowledge. Is there a way to get the formula to skip the blank cells down column E and just use the last value, ie $598.66 in E143 when you get to the next cell that has a value in it, ie E151? </p>
  
  <p>Photo added for reference....</p>
  
  <p><img src="https://i.stack.imgur.com/yvxbJ.png" alt="enter image description here"></p>