See the following example where I have added more cities in the column B and used expression twice. Similarly, you may add more expressions with separate criteria.
![excel countif excel countif](https://www.revisitclass.com/wp-content/uploads/2019/11/countif-in-excel-2-1024x368.png)
![excel countif excel countif](https://cdn.educba.com/academy/wp-content/uploads/2019/09/COUNTIFS-in-Excel.png)
Excel countif plus#
So, one criterion can be specified per expression and plus sign is used. “London” and “New York City”? You may use COUNTIF twice or more for accomplishing this. What if you require the count of two cities in our example sheet i.e. Specifying multiple criteria in COUNTIF function You see, the A8 cell contains “New York City” and the count result is = 2. In that case, the A8 text is used to search and count in the given range (A10 to A20 in that case). For that, you may place the cell after the range as follows: The result is displayed in the B14 cell after using the COUNTIF function.įor this example, rather than providing the text in COUNTIF function, the cell’s text is used as the criterion. The first example demonstrates using the COUNTIF function for counting the occurrence of word “London” in cells range “A2:A12”. If you want to specify more than one, use the COUNTIFS function.Īn example of using Excel COUNTIF with text The COUNTIF can take only one criterion.The criterion is the condition that you want to test.The range specifies where to search in excel sheet (numbers, arrays, a named range or references that contain numbers can be given as range). The syntax of using the COUNTIF function is: Getting employees data between two dates example An example of COUNTIF with dates and range names Using (*) wildcard example in COUNTIF with blank cells Using the number expression – COUNTIF greater than example The example of using multiple criteria by COUNTIFS
![excel countif excel countif](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/06/VBA-COUNTIF.jpg)
An example of using Excel COUNTIF with text