# Count entries with 3 or more conditions

1. ## Count entries with 3 or more conditions

I have a sheet which lists out the percentage of access for different fields , and whether or not a field is active. For example:

Access Percent Active
22 yes
55 no
97 no
12 yes
87 yes
44 yes
65 yes

now I need to get the results for the following:

Number of fields which are active and have access percentage between 35 and 70. For example in this case the answer should be 2.

2. ## Re: Count entries with 3 or more conditions

Try this…

=SUMPRODUCT((A1:A7>=35)*(A1:A7<=70)*(B1:B7>="Yes"))

3. ## Re: Count entries with 3 or more conditions

welcome to the forum bk1983. try:
=SUMPRODUCT((B2:B8="yes")*(A2:A8>=35)*(A2:A8<=70))

4. ## Re: Count entries with 3 or more conditions

Hi

Try this.
Formula:
`Please Login or Register  to view this content.`

5. ## Re: Count entries with 3 or more conditions

Hi and welcome to the forum

If you do have 2003 (as your profile says), use the sumproduct() suggested above. If you have 2007 or later (pleas update your profile), you could look at using the COUNTIFS() function

=COUNTIFS(A2:A20,">=35",A2:A20,"<=70",B2:B20,"yes")

6. ## Re: Count entries with 3 or more conditions

Actually I had tried it before, but hadn't worked. Weird. Guess I didn't put the second set of brackets. Thanks to you both guys

7. ## Re: Count entries with 3 or more conditions

Thank. That has helped.

There are currently 1 users browsing this thread. (0 members and 1 guests)