Skip to Content
0
Nov 27, 2018 at 06:59 PM

Need help with counting

50 Views Last edit Nov 27, 2018 at 06:50 PM 2 rev

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.

Thanks,

Tracy