title: Excel: Sumif Multiple Columns based on the same Criteria
body: <p>So I am trying to create a spreadsheet at allows a character in game to total the party inventory.</p>
  
  <p>I am trying to sumif multiple columns based on the same criteria.</p>
  
  <p>So say I am trying to sum all the rope they have.</p>
  
  <p>In column A is the Item descriptions
  In columns B-E are the different totals for each party member (one column per person)</p>
  
  <p>Each party member has 50 rope, so I am expecting 200 rope.
  I have used this formula:</p>
  
  <p>=SUMIF(A:A,"Rope: Hemp",B:E) and it is only returning 50 as a value, If I utilise cell values (A1:A100 etc.) it returns a value of Zero.</p>
  
  <p>I have been told that Sum Product could works so I also tried that:</p>
  
  <p>=SUMPRODUCT((A1:A100="Rope: Hemp")*(B3:E100)) and I still get the incorrect result.</p>
  
  <p>What am I doing wrong?</p>
  
  <p>EDIT:
  Here are some photos. 
  <a href="https://i.stack.imgur.com/EGyZz.png" rel="nofollow noreferrer">Here is my Raw Data. As you can see I have the inventory and tallies, when you look at rope it says 150, and this was calcualted by summing the B to E cells, however as the list is going to move and grow I thought SUMIF would be better.</a></p>
  
  <p>As stated above, I have used a SUMIF making the range Columns B through E, and it only returns a value of 50 (I'm assuming Column B)</p>