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.


2. What is the Syntax?

=COUNTIF(range, criteria)

  • range   =  The range of cells to count.
  • criteria =  Condition that tells the function which cells to count. It can be a numbertext stringcell 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”)

excel countif function

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…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: