title: Sum vertically until empty cell on Google Sheets
body: <p>This is the scenario. I need to get the sum of the values until it reaches a blank cell. After that it should start again calculating the sum after the blank cell. I need to add the fat and carbs of every ingredient of each dish individually. 
  <a href="https://i.stack.imgur.com/Arxdh.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Arxdh.png" alt="enter image description here"></a></p>
  
  <p>This is the expected result. That for each of hundreds of dishes. In this case I entered the data manually:</p>
  
  <p><a href="https://i.stack.imgur.com/uX72M.png" rel="noreferrer"><img src="https://i.stack.imgur.com/uX72M.png" alt="enter image description here"></a></p>
  
  <p>I tried with this but is adding all of the data from the column: </p>
  
  <pre><code>IF(SUM(C3:C)="","",SUM(C3:C)))
  </code></pre>
  
  <p>I also tried with this formula but is not working: </p>
  
  <pre><code>IF(C3:C="","",SUM(INDIRECT(ADDRESS(ROW(C3:C),COLUMN(C3:C400))&amp;":"&amp;"C"&amp;MIN(ARRAYFORMULA(IF(C3:C400="",ROW(C3:C400),""))))))
  </code></pre>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1IcnSbnWcU59_o1bGWdtBOldg7px34lc631HgZ0K4xRQ/edit?usp=sharing" rel="noreferrer">This is the spreadsheet</a> in case you need it. </p>
  
  <p>Thanks in advance for all the help. </p>