=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!
What is COUNTIFS in Excel? The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria and adjacent or non-adjacent. As a Statistical function of Excel,…
SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.
TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.
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.
LOWER function is used for changing the format of any text or string to LOWER case.
INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.