title: Sum unique values based on another column
body: <p>I have four values: <em>Name, Maturity, Hasinteracted?, SizeofName</em>  </p>
  
  <p><a href="https://i.stack.imgur.com/s7Czc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s7Czc.png" alt="http://i.stack.imgur.com/s7Czc.png"></a>  </p>
  
  <p><strong>Entity</strong> (Constant) - represents the name of the entity.<br>
  <strong>Maturity</strong> (Variable) - In months, how long have they been active with us (i.e. 1 would be one month etc)<br>
  <strong>Hasinteracted?</strong> (True, False) - If yes, their value is TRUE<br>
  <strong>SizeofEntity</strong> (constant) - How large is this entity? This value varies for different Names but is constant for its' own name (i.e. Entity A will always be 12 regardless of their maturity, while Entity B will be 19 regardless of their maturity)</p>
  
  <p><strong><em>What I am trying to do:</em></strong></p>
  
  <p>Using a PivotTable, I have been able to create a table which has <code>Maturity</code> in the rows, and count of interactions for each maturity in the column. </p>
  
  <p>The part that I am struggling with is the total <code>SizeofEntity</code>. Basically, I want it to sum the total <code>SizeofEntity</code>. The issue is that if Entity A repeats in the name section, it will double in this calculation.</p>
  
  <p><strong><em>Example</em></strong></p>
  
  <p>Entity A shows once (size = 12) in maturity 1 and maturity 2, Entity B shows once (size = 19) in maturity 1.</p>
  
  <p>What I am hoping to see in the value section is the total SizeofEntity in Maturity 1 being <code>31</code> and <code>12</code> in Maturity 2, which occurs.</p>
  
  <p><a href="https://i.stack.imgur.com/3Mbcr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3Mbcr.png" alt="http://i.stack.imgur.com/3Mbcr.png"></a>  </p>
  
  <p>Now, if Entity A was to interact twice in Maturity 1, I would want the size to remain same, but the number of interactions to increase. With the way it is currently structured, because Entity A is repeated, the interaction now increases by one, but so does the size of the entity (from <code>31</code> to <code>43</code>). </p>
  
  <p>Is there a way to have Excel ignore the value in the <code>SizeofEntity</code> if the Entity name is repeated in another column, or is there another way to make this possible?  </p>
  
  <p>The data provided in the images is a small example. I am dealing with a much larger dataset with over 300 different names with hundreds of interactions per maturity period.</p>