How to use countifs in excel

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.

countifs excel - How to use countifs in excel

1.1 Calculating the number of male employees with 28 working days.

Syntax: =COUNTIFS(C2:C11,”male”,D2:D11,28)

excel countifs - How to use countifs in excel

The result will output:

countifs function - How to use countifs in excel

1.2 Calculating the number of female employees with days off is 5.

Syntax: =COUNTIFS(C2:C11,”female”,E2:E11,5)

countifs in excel - How to use countifs in excel

The result will output:

how to use countifs in excel - How to use countifs in excel

1.3 Calculate the number of female employees with a 28-day workday and less than or equal to 3 days off.

READ:  How to use countif in excel

Syntax: =COUNTIFS(C2:C11,”female”,D2:D11,28,E2:E11,”<=3″)

countifs not blank - How to use countifs in excel

The result will output:

countifs function in excel - How to use countifs in excel

Add a Comment

Your email address will not be published. Required fields are marked *