How to Use the COUNTIF Function in Excel (Easy Guide)

In today’s tutorial, we will learn about the COUNTIF function. This function is convenient for counting and sorting data. The COUNTIF function allows you to count a number of things, including data and values.

Step-by-step Guide to Use COUNTIF Function in Excel

  1. Start by inputting the formula =COUNTIF( in a cell.
  2. Select the range you want to count. This can be a column or a specific group of cells.
  3. Input the criteria for the count. This can be a number, text, or a cell reference (example: greeted than 100).
  4. Close the formula with a ).
  5. Press Enter to see the result.

Examples

  1. Counting numbers: In the above example, we have a list of numbers, and we want to count how many are greater than 100. To do this, we can use the COUNTIF function. First, we input the formula =COUNTIF(A2:A7, “>100”) and press Enter. This tells Excel to count the number of cells in the range A2:A7 that are greater than 100.
  2. Counting colors: In the following example, we have a list of colors in column C, and we want to count the number of reds. To do this, we can use the COUNTIF function. First, we input the formula =COUNTIF(C2:C7, “red”) and press Enter. This tells Excel to count the number of cells in the range C2:C7 that contain the text “red”.
  3. Counting names: In the following example, we have a list of names in column E, and we want to count the number of names that start with the letter “R”. To do this, we can use the COUNTIF function. First, we input the formula =COUNTIF(E2:E7, “R*”) and press Enter. This tells Excel to count the number of cells in the range E2:E7 that start with the letter “R”.

Conclusion

The COUNTIF function is a useful tool for counting and sorting data in Excel. It has many uses, including counting numbers, colors, and names. With just a few simple steps, we can easily use this function to analyze and understand our data better.