**J**ust in case if we want to find the count of specific items COUNTIF function of excel can come in handy.

Let us see how to use it in detailâ€¦

1. What is COUNTIF Function?

2. What is the Syntax?

3. How to use it with an example?

*1. What is COUNTIF Function?*

*1. What is COUNTIF Function?*

TheÂ **COUNTIF**Â function can be used to count the number of cells that match the criteria.

*2. What is the Syntax?*

*2. What is the Syntax?*

**=COUNTIF(range, criteria)**

**=COUNTIF(range, criteria)**

**range**Â Â =Â The range of cells to count.**criteria =Â**Â Condition that tells the function which cells to count. It can be aÂ*number*,Â*text string*,Â*cell reference*Â orÂ*expression.*

**Note :**

- Strings and logical symbols [i.e. =,+,-,/,*] always need to be enclosed in double quotes.
- Wildcard characters can be used in criteria.
- Criteria are case insensitive i.e. Sharath and SHARATH are same.

*3. How to use it with an example?*

*3. How to use it with an example?*

Assuming we have a column with some data in it

Let’s look at the possible operations…

Want to count sales with the transactions with less than 5000

=COUNTIF(A2:A8,“<5000”)

Few other possible operations…

=COUNTIF(A2:A8,2) //counts the cells which are equal to 2 =COUNTIF(A2:A8,"<"&C1)//counts the cells which are less than the value in C1 =COUNTIF(A2:A8,"sharath") //counts the cells which are equal to "sharath" =COUNTIF(A2:A8,C1) //counts the cells which are equal to value in B1 =COUNTIF(A2:A8,100)+COUNTIF(A1:A10,200) //Adds both the results =COUNTIF(A2:A8,"Raj?") //counts the cells equal to "Raj" and one more char =COUNTIF(A2:A8,"*Sharath*") //count the cells containing "sharath" =COUNTIF(A2:A8,TRUE) //counts the cells equal to TRUE

*Hope it has helped youâ€¦*

Advertisements