title: Google sheets lookup and sum
body: <p>I have a production schedule where cells are filled with text: </p>
  
  <p>Day 1, Day 2 etc.</p>
  
  <p>And I'd like these cells to be associated with values elsewhere in the same sheet. </p>
  
  <p>For example. Day 1 would be 4 (which corresponds to 4 hours).</p>
  
  <p>Then I have to sum these cells/values (Day 1 = 4 + Day 2 = 6) to get a total for each row.</p>
  
  <p>I can't seem to find a way to do all this using one formula. Is it even possible?</p>
  
  <p>Feel free to <a href="https://docs.google.com/spreadsheets/d/1eP_gfRM7uVVv2QTPEw0ylqDMFJjhNPoRDXl8FphUiGQ/edit#gid=0" rel="nofollow noreferrer">check out the sheet</a>.</p>