Hi - I am not even sure how to word my question so I will use a rough example.
Each person below has the following values:
Person a – 1,2,3,4,5
Person b – 2,4,6
Person c – 1,2,4,6
Person d – 1,3,5
I can see that the number of people where value =1 is 3 and the number of people where value = 2 is 3, etc.
How do I count the number of people who have both values = 1 and 6? In the above example, the count should be 1. We are using this formula
=Count([person]) Where (([value]="1") And ([value]="6"))
This returns nothing because there is no one who only has 1 and 6. What is the formula when the people have other values but I only care about the combination of 1 and 6?
I hope my example helps someone to help me with this problem.