=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!
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
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
VBA Code to Count Color Cells With Conditional Formatting Have you ever got into situation in office where you need to count the cells with specific color in conditional formatted Excel sheet? If yes then…
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…
SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.
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