title: Formula in Excel to add values based on a merged cell
body: <p>I have a problem: a customer wants to have 14 columns of numbers added up by a client, but the client is on multiple different lines or sometimes only one. 
  Even worse, the client name cells are merged and a VLOOKUP only gives me back the top value. 
  Is there a way to add all the columns under the criteria of client (John for instance in the table below)? And then copy that formula down the list and have it change depending upon the number of times the client's name comes up?</p>
  
  <p>*This is a mock of the problem, all fake info</p>
  
  <pre><code>Column A    Column B    Column C    Column D    Column E
  JOHN        500           1000      Total(B:C)  Total for Johns (B:C)'s
              600           6007      Total(B:C)
              550           1000      Total(B:C)
  JANE        1200         15220      Total(B:C)  Total for Jane's (B:C)'s
  CARL        1400          5430  
              500           5610                  Total for Carl's (B:C)'s
  AL          700          15112  
  AL          8000          1677  
  </code></pre>