title: Complicated array function with multiple criteria
body: <p>I have tables which look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/mbGVo.png" alt="Link"></p>
  
  <p>I want to filter out the sum of the maximum values in column C for every unique text value in column A, where the value in column B equals "d".</p>
  
  <p>So for the linked example, the result would be a sum of <code>C3+C6+C9</code> equaling 9. I am able to get the right results using pivot tables, macros etc., but I'm looking to solve it with a single function.</p>