How to use countif in excel (Step-by Step)

July 26, 2022
3.7K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Excel's potent COUNTIF function allows you to count cells according to a single criterion. 

Numeric Criteria in excel online, 2016 and 2019

 To count cells that are more than or equal to a value, count cells that are equal to a value, etc., use Excel's COUNTIF function.

The number of cells that equal 20 is counted using the COUNTIF function below.

1.The COUNTIF function that follows produces the same outcome.

2.The cells that have a value greater than or equal to 10 are counted by the COUNTIF function below.

3.The COUNTIF function that follows produces the same outcome.

4.The number of cells that are less than 7 is counted by the COUNTIF function below.

5.The COUNTIF methods listed below count how many cells have values of 3 or 7.

Text tricks in excel

1.To count cells that contain a certain text, use Excel's COUNTIF function plus a few shortcuts. Text should always be encased in double quotation marks.The number of cells that contain exactly star is counted using the COUNTIF function below.

2.The COUNTIF function listed below determines how many cells have exactly star + 1 character. A question mark (?) corresponds to one single character.

3.Using the COUNTIF function, we can determine how many cells have exactly star + a string of zero or more characters. A series of zero or more characters is indicated by an asterisk (*).

4.The number of cells that include star in any fashion is counted using the COUNTIF function below.

5.The number of cells with text is counted using the COUNTIF function below.

Count Booleans in excel

1.To count Boolean values in Excel, use the COUNTIF function (TRUE or FALSE).The number of cells that have the Boolean value TRUE is counted using the COUNTIF function below.

2.The number of cells that contain the Boolean value FALSE is counted using the COUNTIF function below.

Count errors in excel

1.To count certain errors, use Excel's COUNTIF function.The number of cells that have the #NAME? error is counted using the COUNTIF function below.

2.The array formula below counts all faults over a set of cells.

3.By hitting CTRL + SHIFT + ENTER, you can complete an array formula. The curly braces are added by Excel. Lastly, simply hit Enter to complete. Curly braces won't be seen

Note: This above written article was an attempt to show you how to use countif in excel online, 2016 and 2019 in both windows and mac.You just need to have a little understanding of how and which way things work. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.