- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Countif with Multiple Criteria in Excel?
You can use the potent COUNTIF function to count the number of cells in a range that satisfy particular criteria. Although only one criterion may be handled at a time by the basic COUNTIF function, there are several circumstances where you may need to count cells that satisfy several criteria at once.
You will have a thorough understanding of how to count cells in Excel using numerous criteria at the end of this course, enabling you to assess and summarise your data quickly. Let's dive in and learn more about COUNTIF's world of numerous criteria!
Countif with Multiple Criteria in Excel
Here we will look at different scenarios for using multiple criteria. So let us see a simple process to know how you can count with multiple criteria in Excel.
Step 1
Consider an Excel sheet where you have the required data.
First, to count cells based on text value in a single column, click on an empty cell and enter the formula as =COUNTIF($A$2:$A$15,"KTE")+COUNTIF($A$2:$A$15,"KTO") then click enter. In the formula A2:A15, the range of cells
Empty Cell > Formula > Enter.
Step 2
Then count multiple criteria based on two values. Click on an empty cell and enter the formula as =COUNTIF($A$2:$A$9,">50")-COUNTIF($A$2:$A$9,">100") and click enter. In the formula B2:B15, the range of cells
Empty Cell > Formula > Enter.
Step 3
Finally, to count the cells between two dates, click on an empty cell and enter the formula as =COUNTIFS($B$2:$B$15, ">=5/1/2019", $B$2:$B$15, "<=8/1/2019") and click enter. In the formula B2:B15, the range of cells
Empty Cell > Formula > Enter.
This is how you can count with multiple criteria in Excel.
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can count with multiple criteria in Excel to highlight a particular set of data.