How to Use COUNTIFS Function (Formula) In Excel

COUNTIFS

Use of COUNTIFS Function (Formula) In Excel

This function in Microsoft Excel Counts the number of cells specified by a given set of conditions or criteria.

Syntax/Formula of COUNTIFS Function

The syntax of COUNTIFS function in Microsoft Excel is below.

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], …)

Example of COUNTIFS Function in Excel

In below Example we need Unpaid Count Status of ATK PVT LTD.

So in this case we use COUNTIFS function.

Step1: First create below table in your excel starting from cell range A1 to D11.

Step2: Type formula =COUNTIFS(B1:B11,"ATK PVT LTD",D1:D11,"Unpaid") in cell A14 and press enter.

In Above formula B1:B11 is criteria_range1 (Company Name).

"ATK PVT LTD" Is our criteria1.

D1:D11 is criteria_range2 (Status).

"Unpaid" Is our criteria2.

COUNTIFS Function