title: How to calculate total of partial matches for dataset?
body: <p>I'm trying to figure out how to calculate when, in a set of rows, any 2 of them match from 3 criteria.</p>
  <p><a href="https://i.stack.imgur.com/tzJiu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tzJiu.png" alt="enter image description here" /></a></p>
  <p>So (6 isn't the correct answer, just an example), I would be trying to calculate how many of the rows contained 2 out of the three criteria: Cats, Dogs, Parrots. So each permutation is accounted for - Cats, Dogs, Lions would be valid, for example, but Cats, Hippos, Gazelle would not.</p>