title: Get maximum string of semicolon-separated values in a cell
body: <p>I am trying to sum all the values that belong to a squads that have been completed in a sprint. I have source table that contains 3 columns (Squad Name, Value, Sprint). The Sprint column has cells that contain semicolon-separated lists.</p>
  <p><img src="https://i.stack.imgur.com/5QDAs.png" alt="Source Data" /></p>
  <p>What I am trying to achieve is sum all values in Column B where the criteria are:</p>
  <ol>
  <li>Squad name = Tigers</li>
  <li>MAX Sprint = Sprint 11</li>
  </ol>
  <p>I would like to sum those values in Column B where the max sprint value in Column C is Sprint 11. I would not like to include those values where the max value in Column C is sprint 12.</p>
  <p>At the moment I have got:
  =SUMIFS(B2:12,A2:12,&quot;Tigers&quot;,C2:C12,...)</p>
  <p>Can someone help me figure out the last bit?
  Thanks</p>