title: How do I sum up the value of a column where a given value exists in another column?
body: <p>Each row in my sheet represents a transaction. One column (G) contains the client name and another column (H) contains the GP from the exchange. </p>
  
  <p>I'm trying to make a report in another sheet that references these cells to get GP info for each of our clients.</p>
  
  <p>The formula I'm trying to accomplish is this: <strong>Sum up the GP (column H) from every row containing [ClientID] in <code>Column G</code></strong></p>
  
  <p>The <code>ClientID</code> is on Column G and <code>GP</code> is on Column H</p>
  
  <p>I would like to make this process automated so that each time a transaction is entered, the Client GP sheet will be automatically updated. </p>
  
  <p>Thanks. </p>