title: Calculate Highest value of Serialized and non-Serialized values
body: <p>I am trying to find the highest value of a mix of serialized and non-serialized values via Google Sheets.  Ideally, I'd prefer a single-cell formula but multiple cells is fine.</p>
  <pre><code>NormalValue1 = 10
  Serialied1   = 30
  NormalValue2 = 60
  Serialized1  = 10
  Serialized2  = 5
  Serialized2  = 5
  </code></pre>
  <p>The expected results would be:</p>
  <pre><code>Serialized1 = 40 (30+10)
  Serialized2 = 10 (5+5)
  
  NormalValue Highest = 60
  Serialized  Highest = 40 (Serialized1 at 30+10)
  Final result:       = 60
  </code></pre>
  <p>Here's an example of what I'd ultimately like to have.
  <a href="https://i.stack.imgur.com/AL9pC.png" rel="nofollow noreferrer">Example table from Google Sheets</a></p>