title: COUNTIF across multiple sheets with dupilcate detection
body: <p>Was hard to give this question an accurate title, so sorry if its wrong.</p>
  
  <p>Anyway, given the following data...</p>
  
  <p><img src="https://imgur.com/fsMaxh5.jpg" alt="Example1"></p>
  
  <p>With each sheet being a different player I need to count the number of games played in each colored room across all players.</p>
  
  <p>That's easy enough with countif..</p>
  
  <p><img src="https://imgur.com/aECA2i7.jpg" alt="Example2"></p>
  
  <p>But some games have multiple players and in those cases the game would be counted multiple times using the above method. </p>
  
  <p>One solution I'm trying giving each game with multiple players an ID, a random string, then checking if an ID is present and if so, only count all games with the same ID as one. </p>
  
  <p>The end result should end up like this.</p>
  
  <p><img src="https://imgur.com/pxA3O0L.jpg" alt="Example3"></p>
  
  <p>Despite my effort I havent been able to figure this out. Anyone have any tips on how to go about this? or if there is a better way to prevent the same game from being counted twice.</p>
  
  <p>If possible I'd like to avoid using the apps-script.
  Thanks.</p>