=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!
MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]
ROUND function rounds the number value to nearest digit mentioned in argument.
ROUND function has two required arguments i.e. number and num_digits
MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1
Excel Function DATE While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that…
MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.
COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.