How to use the COUNTIF Function

Microsoft Excel COUNTIF function one of the most important functions because of its property to give the count number using the given criteria.

In this article we'll discussion about COUNTIF step-by-step. Its very easy quick working formula...

Description

COUNTIF is a function in Excel to count cells that meet a single criteria. COUNTIF can be used to count cells with dates, numbers, and text that match specific criteria. The COUNTIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Excel File Download Link : COUNTIF Tutorial Excel

But, remember you need to put logical operators within double quote. Non-numeric criteria needs to be enclosed in double quotes but numeric criteria does not require quotes.

Syntax

The syntax for the COUNTIF function in Microsoft Excel is:

COUNTIF (range, criteria)

Arguments

range - The range of cells to count.

criteria - The criteria that controls which cells should be counted.

The COUNTIF function in Excel counts the number of cells in a range that match the supplied criteria

    COUNTIF(A1:A10,100)          // count cells equal to 100

    COUNTIF(A1:A10,">32")      // count cells greater than 32

    COUNTIF(A1:A10,"Tim")      // count cells equal to "Tim"

    COUNTIF(A1:A10,"<"&B1)  // count cells less than value in B1

Follow the bellow image. For more clarification about this function you can watch my YouTube video by clicking Countif.

Countif Function in Excel

    

       OR  you can watch here....