How to use the countif function in excel

Excel lets you organize, analyze, and track large amounts of data to simplify your work. It offers special functions like the COUNTIF function, and if you want to learn how to use the countif function in excel, you are in the right place.

COUNTIF is a popular Excel formula that allows you to count the cells in a range that matches single or multiple conditions. Counting cells with texts and numbers that meet the criteria is useful. Below you will know how to use the countif function in excel.

1. how to use the countif function in excel in numerical criteria

If you want to learn how to use the countif function in excel mac, you will need to know that Excel counts cells based on criteria. Here are the steps to use COUNTIF on numeric criteria:

1. In this example, the COUNTIF function will be used to count cells equal to 20. You can see the formula in the following image.

2. The following COUNTIF function will give the same result. See the formula in the image.

3. The following COUNTIF function will count the number of cells equal to or greater than 10.

4. As you can see, the following COUNTIF function gives the same result.

Note: The & operator joins the greater than or equal to symbol and the value in cell C1.

5. The following COUNTIF formula counts the number of cells that are not 7.

6. This COUNTIF function formula will count the number of cells equal to 3 or 7.

2. how to use the countif function in excel in cells containing specific text

If you want to learn how to use the countif function in excel 2016 to count cells with specific text, you need to follow these steps:

1. For this step, you will need to enclose the text in quotes, as shown in the image. The number of cells containing exactly stars will count.

2. With the following COUNTIF formula, you can count the number of cells that contain exactly one star + 1 character. A question mark (?) matches exactly one character, as shown in the image below

3. In the following example, you will be able to count the number of cells that contain exactly an asterisk + a string of zero or more characters. An asterisk (*) matches a string of zero or more characters.

4. Now, with the following COUNTIF function, you can somehow count the number of cells that contain stars.

5. The function below will allow you to count the number of cells that contain text.

3. how to use the countif function in excel to count booleans

You can also learn how to use the countif function in excel 2019 to count boolean values (TRUE or FALSE. For this process, you will need to execute the following steps:

1. In this example, the COUNTIF formula will count the number of cells that contain boolean TRUE.

2. With the following function, COUNTIF will count the number of cells that contain the boolean value FALSE.

By learning how to use the countif function in excel online, you will also learn how to count specific errors. You have to follow the following steps:

1. Using the following COUNTIF function, you will be able to count the number of cells that contain the •NAME? Mistake.

2. The following array formula will allow you to count the total number of errors in a range of cells, as shown in the image.

Note: You must finish the array formula by pressing Ctrl + Shift + Enter. This way, Excel will add the braces {}.

3. To finish, press Enter.

Conclusion

Have you learned how to use the countif function in excel? You can use the COUNTIF function with the examples mentioned above conveniently and easily. With COUNTIF formulas, you can count all cells in a range that contains numbers and text.

If you want to learn new special Excel functions, you can also follow WPS Academy. In addition, you can download WPS Office to create, process, and edit Excel, PowerPoint, and Word documents for free.