=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
criteria_range1 argument is used to give the range in which criteria1 needs to find
criteria1 argument is used to give criteria for count. We can give value (example “A”, >10, 50) or cell reference# (example: F2) in this argument
[criteria_range2] optional argument is used to give the ANOTHER range in which criteria2 needs to find
[criteria2] optional argument is used to give criteria2 for count. Value or cell reference# can be given.
Kindly note, we can add multiple criteria in the function by separating them with Comma ( , )
Here, we want to get the count of students who obtained Grade A:
We will be using COUNTIFS function as follows:
Here, we want to get the count of Male Students (criteria1) who have obtained Grade A (criteria2):
We will be using COUNTIFS function as follows:
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.
This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.
So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.
We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion
This course is going to help you to excel your skills in Excel VBA with our real time case studies.
Lets get connected and start learning now. Click here to Enroll.
Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community
INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.
RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank
Merge Cells in Excel Merge cells is to combine multiple cells into one cell which can further be used for giving title to the report or header to the column. It helps to create clean…
SUM Function in Excel Excel is a mathematical spreadsheet where you can perform multiple calculations with the help of Excel Formulas. These are automated formulas which refreshes automatically once you refresh your data in a…
COUNTA function is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2
Excel Function ISERROR Microsoft Excel “ISERROR Function” is a Logical Function and it is used to check if cell contains any “ERROR”. “ISERROR Function” is used as a test to validate if cell contains any…