by The COUNTIFS function in Excel is used to count cells but meets certain conditions. The COUNTIFS function is one of the most used statistical Excel functions in Excel, the advanced function of the COUNTIF function only counts cells with a given condition. When done with the COUNTIFS function, users can easily find the result cell that satisfies the conditions specified in the request. Conditions can be numbers, dates, text or cells containing data. The following article will guide you how to use the COUNTIFS function in Excel.
How to use countifs in excel
The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.
Syntax:= COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
The COUNTIFS function syntax has the following arguments:
- Criteria_range1: Required. The first range in which to evaluate the associated criteria.
- criteria1: Required. The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, “>32”, B4, “apples”, or “32”.
- Criteria_range2, criteria2, …: Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.
Example: We have the following data table to make some requests for the table.
1.1 Calculating the number of male employees with 28 working days.
Syntax: =COUNTIFS(C2:C11,”male”,D2:D11,28)
The result will output:
1.2 Calculating the number of female employees with days off is 5.
Syntax: =COUNTIFS(C2:C11,”female”,E2:E11,5)
The result will output:
1.3 Calculate the number of female employees with a 28-day workday and less than or equal to 3 days off.
Syntax: =COUNTIFS(C2:C11,”female”,D2:D11,28,E2:E11,”<=3″)
The result will output:
