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…

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply