title: How do I sum horizontally across a row based on 1st column value?
body: <p>I've used the search but haven't found much on this.  Essentially I would like to do a <code>SUMIF</code> style action on a dataset but it only grabs the first adjacent value.  My table would be something like:</p>
  
  <pre><code>KT    4    5    9
  AM    3    7    8
  IA    2    5   12
  </code></pre>
  
  <p>On rows below I would have</p>
  
  <pre><code>KT |  =Sumif(A1:E3,A8,B1:E3)   Which returns 4
  AM |  =Sumif(A1:E3,A9,B1:E3)   Which returns 3
  IA |  =Sumif(A1:E3,A8,B1:E3)   Which returns 2
  </code></pre>
  
  <p>Now I know I could surely just add a column with a total use <code>vlookup(array, value, index)</code> but that is not what I want to do (although I may just do so if this is too big a pain).</p>
  
  <p>Any thoughts/ideas.  Demo <a href="https://docs.google.com/spreadsheets/d/1pg1sdXm4IUrKU4NDLUSibvfaPnXF-TbBevt2u4RPgNI/edit?usp=sharing" rel="nofollow">here</a></p>