=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!
Calculations With Date In Excel Dates function also be used to subtract the Year, Month and Days from the existing dates. Sometimes we need to subtract specific period from the date. In case you are…
Excel Function COUNTIF COUNTIF Excel Function is also one of the most used function in excel. This helps the user to calculate the number of counts based on single logic given by the user. You…
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7
AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.