title: Using SUMIF on a range of columns or SUMPRODUCT to ignore text items
body: <p>I have a range with various text and numbers in them. I wish to total the numbers based on the identifying first column.</p>
  
  <p>I have tried </p>
  
  <p><code>=SUMIF(A1:A20,"John",B1:E20)</code></p>
  
  <p>which only returns the first columns number. I've also tried </p>
  
  <p><code>=SUMPRODUCT((A1:A20="John")*(B1:E20))</code></p>
  
  <p>but as there is text in column C, it returns #VALUE!.</p>
  
  <p>A |  B  | C |  D |  E</p>
  
  <p>John  |   5     |  Wine |    2   |    7</p>
  
  <p>Sean  |   6     |  Beer |    5   |    2</p>
  
  <p>I want all of the numeric values in columns B-E to be totalled together when "John" is in column A</p>