COUNTIF Function

There are various methods used to count cells in Excel. We will be utilizing the COUNT function.

• The COUNTIF function is used to count cells in a range given a certain criteria.

The examples listed below show how to properly use the COUNT function in Excel. In every example, the data range that will need to be changed is titled “range.”

Use of the COUNT function Examples

To count the number of cells that contain the word “buddy”:

=COUNTIF(range,"criteria")

=COUNTIF(range,"buddy")

The asterisk “*” is your friend

To count the number of cells that contain any text:

=COUNTIF(range,"*")

To count the number of cells that contain text that begins with the letter “b”:

=COUNTIF(range,"b*")

To count the number of cells that contain the letter “b”:

=COUNTIF(range,"*b*")

Count Functions with exact criteria

To count the number of rows where the cell is greater than or equal to a given number:

=COUNTIF(B1:B10,”>=10″)

To count the number of cells that contain either “yes” or “no”:

=COUNTIF(range,"yes")+COUNTIF(range,"no")

To count the number of cells that contain a value between 1 and 10:

=COUNTIF(range,">=1")-COUNTIF(range,">10")