title: How do you sum the single max values of multiple groups?
body: <p>I have a data table which, among other things, contains a list of Values, each is assigned a Group ID.</p>
  
  <p>I would like to sum the max value of each group.</p>
  
  <p>I can do this easily by using a helper table (with MAXIFS) as can be seen below. However, for various reasons, I would like to avoid any helper columns/tables and produce the result from a single, non-CSE, formula.</p>
  
  <p><a href="https://i.stack.imgur.com/grsSC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/grsSC.png" alt="enter image description here"></a></p>
  
  <p>How can this be done?</p>