# How To Use Excel COUNTIF Function – Quick Guide

Just 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?

TheÂ COUNTIFÂ function can be used to count the number of cells that match the 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?

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â€¦