Count overlapping groups without counting people twice
Two valid memberships need not mean two different people.
When a person belongs to both groups, adding group sizes counts that person twice. For distinct people in their union, subtract the intersection once. Both memberships are valid; neither needs deleting as an error.
What to do
- Establish that the overlap means the same people, not a number of visits.
- Split membership into three disjoint regions: first only, both, second only.
- Add the regions and check with first group size plus second minus the overlap.
Example
Fictional club: 4 people draw, 6 take photographs, and 2 belong to both groups. Regions: drawing only 2, both 2, photography only 4. Altogether, 4+6−2=8 distinct people belong to at least one group.
My Day · Windows
My Day can hold the regions and calculation. You check membership and counts yourself.