How to use COUNTIF Function (Formula) In Excel

COUNTIF

Use of COUNTIF Function (Formula) In Excel

This function in Microsoft Excel counts the number of cells within a range that meet the given condition.

Syntax/Formula of COUNTIF Function

The syntax of COUNTIF function in Microsoft Excel is below.

=COUNTIF(range, criteria)

Example of COUNTIF Function in Excel

In below Example we need Total Count of Paid Payment Amount.

So in this case we use COUNTIF function.

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

Step2: Type formula =COUNTIF(D1:D11,"Paid") in cell A14 and press enter.

In Above formula D1:D11 is range (Status).

"Paid" Is our criteria.

COUNTIF FUNCTION