Forum Discussion
Using countifs with two variables searching a range of columns
I am trying to create an interactive worksheet that counts the number of times two conditions are met using a drop down menu to select the conditions. The conditions are hosted in a range of columns....
Hi Dan,
What you try to count that's the number of cells in columns from B to F for which the value simultaneously equals to F3 AND H3. Most probably there are no such cells.
What you really would like to count it's bit hard to understand without the sample.
Here is an example of what I am trying to do. I created a smaller version to share. The data is in columns B:F, I3 and K3 are the dropdown menus, and the formula =COUNTIFS(B2:F11,I3,B2:F11,K3) is in I6. As you can see there are two rows that match the conditions of Female and Choir but the formula returns 0
- try:
=COUNTIFS(B2:B11,I3,E2:E11,K3)
HTHarrange your lookup - do not mix up all data in one list
also you can have more than 2 criteria - just lookup at the proper column
