How to work with COUNTIF with multiple criteria

< Back to Search results

 Category: [Excel]  Demo Available 

How to work with COUNTIF with multiple criteria




The user is looking for a formula solution to return a line count for one of three groups that meet one of four status in any one of four categories.

  A B C D E F
1 Name
2 Fred L C P F B
3 Harry I P C E S
4 Jim N S N N R
5 Stuart N N I P R


So, How many lines contain "R" in column F, that have either "C" or "P" or "I" or "F" in columns B or C or D or E?
The answer for the above example should be 1.

The formula the user would rework to query the same for Groups "B" and "S".






Obtained from the OzGrid Help Forum.

Solution provided by NBVC.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to use Index/Countif based on multiple factors including range
How to count the frequency of a specific number on a specific day
How to count non blanks 5 years from the last non blank date
How to count worksheets


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.




stars (0 Reviews)