title: How to sum a row contains text, and each text is equal a given specific value in google spreadsheet
body: <p>In google spread sheet, Given the following:</p>
  
  <pre><code>John      5
  Peter     0
  Brad      3
  Smith     1
  
  Grade1    1
  Grade2    2
  Grade3    3
  Grade4    4
  
  Pass      5
  Fail      0
  </code></pre>
  
  <p>I want to do the following, when I write in the same row say (John   Grad1   Pass), it should sum all values of each word, so I should get "11" in this case. Below some examples:</p>
  
  <pre><code>Peter  Grade2  Fail   2
  Smith  Grade4  Pass   10
  </code></pre>
  
  <p>etc..</p>
  
  <p>How can I do this?</p>