{"id":4595,"date":"2017-12-02T02:07:52","date_gmt":"2017-12-02T02:07:52","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=4595"},"modified":"2023-10-31T19:12:49","modified_gmt":"2023-10-31T19:12:49","slug":"12-examples-excel-countif-function-understand-thoroughly","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/","title":{"rendered":"COUNTIF Function in Excel"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-9705\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-COUNTIF-Function.jpg\" alt=\"Infographic: Excel COUNTIF Function Tutorial - Demonstrating COUNTIF function usage, purpose, features and formula examples\" width=\"1200\" height=\"630\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-COUNTIF-Function.jpg 1200w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-COUNTIF-Function-300x158.jpg 300w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-COUNTIF-Function-1024x538.jpg 1024w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/Excel-COUNTIF-Function-768x403.jpg 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<ul class=\"has-left-border-and-background-color\">\n<li>In this tutorial, you'll master the Excel COUNTIF function, a handy function for counting specific data within a <a href=\"https:\/\/www.excel-learn.com\/excel-vba-range\/\">range<\/a>.<\/li>\n<li>Whether you need the count of <strong>words<\/strong>, <strong>numbers<\/strong>, or <strong>dates<\/strong>, COUNTIF can save you time and streamline your data analysis.<\/li>\n<li>The tutorial covers the basics, such as counting words or phrases in a range and using cell text as criteria.<\/li>\n<li>It then delves into advanced techniques like counting with <strong>multiple criteria<\/strong> and introduces the COUNTIFS function for more complex tasks. You'll also learn to count based on numerical conditions and leverage <strong>wildcard characters<\/strong> like \"<strong>*<\/strong>\" and \"<strong>?<\/strong>\".<\/li>\n<li>By the end, you'll be equipped to handle various Excel counting scenarios efficiently.<\/li>\n<\/ul>\n<h3>COUNTIF - An Introduction<\/h3>\n<p>You want to count the number of times the word \u201cMicrosoft\u201d appears from the <strong>cell A2 to A1000<\/strong>. How can you do that? One way is to go through each cell one by one and keep adding as you find a match OR<\/p>\n<p>Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.<\/p>\n<p>Simply provide the range and criteria in the COUNTIF Excel function as follows:<\/p>\n<p class=\"codediv\">=COUNTIF(A2:A1000,\"Microsoft\")<\/p>\n<p>Just select the cell where you want to display the result and there you go! So, In the COUNTIF function, you need to specify<\/p>\n<ul>\n<li>Where to search?<\/li>\n<li>What to search?<\/li>\n<\/ul>\n<p>In the next section, I will show you a variety of examples of using the COUNTIF function in excel with images, so keep reading.<\/p>\n<h3><strong>Syntax of the COUNTIF function<\/strong><\/h3>\n<p>The syntax of using the COUNTIF function is:<\/p>\n<blockquote><p>COUNTIF(range, criteria)<\/p><\/blockquote>\n<p>Where:<\/p>\n<ul>\n<li>The <strong>range<\/strong> is required. The range specifies where to search in Excel sheet (numbers, arrays, a named range, or references that contain numbers can be given as a range).<\/li>\n<li>The <strong>criterion<\/strong> is the condition that you want to test. It may contain text e.g. \u201cLondon\u201d, cells reference e.g. C34, numbers e.g. 10, 20, 30, or comparisons e.g. \u201c&gt;15\u201d, \u201c&lt;100\u201d and so on. This is also <strong>required<\/strong>.<\/li>\n<li>The COUNTIF can take only one criterion. If you want to specify more than one, use the COUNTIFS function.<\/li>\n<li>The criteria are case insensitive.<\/li>\n<\/ul>\n<h3><strong>An example of using Excel COUNTIF with text<\/strong><\/h3>\n<p>The first example demonstrates using the COUNTIF function for counting the occurrence of word \u201cLondon\u201d in cell range \u201cA2:A12\u201d.\u00a0 The result is displayed in the B14 cell after using the COUNTIF function.<\/p>\n<p>This is how COUNTIF is used:<\/p>\n<p class=\"codediv\">=COUNTIF(A2:A12,\"London\")<\/p>\n<p><strong>The resulting image:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4596\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.1-Excel-COUNTIF.png\" alt=\"Excel COUNTIF\" width=\"494\" height=\"369\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.1-Excel-COUNTIF.png 494w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.1-Excel-COUNTIF-300x224.png 300w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/p>\n<h3><strong>The example of COUNTIF with cell text<\/strong><\/h3>\n<p>For this example, rather than providing the text in COUNTIF function, the cell\u2019s text is used as the criterion. For that, you may place the cell after the range as follows:<\/p>\n<p class=\"codediv\">=COUNTIF(A10:A20,A8)<\/p>\n<p>In that case, the A8 text is used to search and count in the given range (A10 to A20 in that case). See the following example:<\/p>\n<p><strong>The formula:<\/strong><\/p>\n<p class=\"codediv\">=COUNTIF(A2:A12,A8)<\/p>\n<p><strong>The resulting image:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4597\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.2-Excel-COUNTIF-cell.png\" alt=\"Excel COUNTIF cell\" width=\"428\" height=\"404\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.2-Excel-COUNTIF-cell.png 428w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.2-Excel-COUNTIF-cell-300x283.png 300w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/p>\n<p>You see, the A8 cell contains \u201cNew York City\u201d and the count result is = 2.<\/p>\n<h3><strong>Specifying multiple criteria in COUNTIF function<\/strong><\/h3>\n<p>What if you require the count of two cities in our example sheet i.e. \u201cLondon\u201d and \u201cNew York City\u201d? You may use COUNTIF twice or more to accomplish this. For example:<\/p>\n<p class=\"codediv\">=COUNTIF(A10:B10,A5)+COUNTIF(A12:B24,B7)<\/p>\n<p>So, one criterion can be specified per expression, and a <strong>plus sign<\/strong> is used. Similarly, you may add more expressions with separate criteria.<\/p>\n<p>See the following example where I have added more cities in column B and used the expression twice. The result should be the count of London and New York City. See the formula and output:<\/p>\n<p><strong>The formula for using COUNTIF in Excel twice:<\/strong><\/p>\n<p class=\"codediv\">=COUNTIF(A2:B12,\"London\")+COUNTIF(A2:B12,A2)<\/p>\n<p><strong>The count result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4598\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.3-COUNTIF-multiple.png\" alt=\"COUNTIF multiple\" width=\"578\" height=\"401\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.3-COUNTIF-multiple.png 578w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.3-COUNTIF-multiple-300x208.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<p>You see, the occurrence of London is ten times while New York City is 4 times, and the total count is displayed as 14.<\/p>\n<p><strong><em>Note:<\/em><\/strong><em> Alternatively, you could also use COUNTIFS function for multiple criteria. See the example below.<\/em><\/p>\n<h3><strong>The example of using multiple criteria by COUNTIFS<\/strong><\/h3>\n<p>In the following example, two criteria are specified by using the COUNTIFS function of excel. The occurrence of London in column A with corresponding numeric value in column B. We will get the count of London and a value greater than 1. See the result and formula:<\/p>\n<p>Formula:<\/p>\n<p class=\"codediv\">=COUNTIFS(A2:A12,\"London\",B2:B12,\"&gt;1\")<\/p>\n<p><strong>The count:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4599\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.4-COUNTIFS-Excel.png\" alt=\"COUNTIFS Excel\" width=\"512\" height=\"403\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.4-COUNTIFS-Excel.png 512w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.4-COUNTIFS-Excel-300x236.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>Although\u00a0the London occurrence is five times, however, in column B, one corresponding numeric value is 1, so the count is 4.<\/p>\n<h3><strong>Using the number expression \u2013 COUNTIF greater than the example<\/strong><\/h3>\n<p>As mentioned earlier, you may also use the expression in the Excel COUNTIF function. For example:<\/p>\n<table width=\"357\">\n<tbody>\n<tr>\n<td width=\"114\"><strong>Expression\u00a0<\/strong><\/td>\n<td width=\"243\"><strong>Description<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"114\">\"&gt;\"<\/td>\n<td width=\"243\">Greater than<\/td>\n<\/tr>\n<tr>\n<td width=\"114\">\"&lt;\"<\/td>\n<td width=\"243\">Less than<\/td>\n<\/tr>\n<tr>\n<td width=\"114\">\"&lt;=\"<\/td>\n<td width=\"243\">Less than or equal to<\/td>\n<\/tr>\n<tr>\n<td width=\"114\">\"&gt;=\"<\/td>\n<td width=\"243\">Greater than or equal to<\/td>\n<\/tr>\n<tr>\n<td width=\"114\">\"&lt;&gt;\"<\/td>\n<td width=\"243\">Not equal to<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>In the next example, we will count how many Months have sales over 1000. For that, we have a Month column (A) and the other represents the number of sales (B).<\/p>\n<p><strong>Formula applied:<\/strong><\/p>\n<p class=\"codediv\">=COUNTIF(B2:B13,\"&gt;1000\")<\/p>\n<p><strong>Count result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4600\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.5-COUNTIF-greater-than.png\" alt=\"COUNTIF greater than\" width=\"495\" height=\"416\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.5-COUNTIF-greater-than.png 495w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.5-COUNTIF-greater-than-300x252.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/p>\n<h3><strong>The example of not equal to &lt;&gt; operator<\/strong><\/h3>\n<p>We will use not equal to operator with cell rather than a direct value. The requirement is to return the count of sales in a Month not equal to 1500. Have a look how it is done.<\/p>\n<p><strong>Formula:<\/strong><\/p>\n<p class=\"codediv\">=COUNTIF (B2:B13,\"&lt;&gt;\"&amp;B2)<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4601\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.6-COUNTIF-not-equal-to.png\" alt=\"COUNTIF not equal to\" width=\"428\" height=\"416\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.6-COUNTIF-not-equal-to.png 428w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.6-COUNTIF-not-equal-to-300x292.png 300w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/p>\n<p>Did you notice the ampersand (&amp;) sign? This is used to merge the comparison operator with the cell value. It makes value of B2 for reading as:<\/p>\n<p class=\"codediv\">=COUNTIFS(B2:B13,\"&lt;&gt;1500\")<\/p>\n<p>If we had used the <strong><em>=COUNTIFS(<\/em>B2:B13<em>,\"&lt;&gt;\"B2)<\/em> <\/strong>(without \u2018&amp;\u2019) then the result would have been 12.<\/p>\n<p><em>Tip: So be careful as you intend to compare numbers and taking the value of cells.<\/em><\/p>\n<h3><strong>Using multiple expressions example<\/strong><\/h3>\n<p>You may also use multiple expressions for defining two or more conditions.\u00a0 For example, return the Months count (in our example sheet), with sales greater than or equal to 1200 and less than 1800.<\/p>\n<p>This is how it can be translated into Excel\u2019s COUNT <a href=\"https:\/\/www.excel-learn.com\/excel-function-explained-5-formulas\/\">IF function<\/a>:<\/p>\n<p>Formula:<\/p>\n<p class=\"codediv\">=COUNTIF(B2:B13,\"&gt;=1200\")+COUNTIF(B2:B13,\"&lt;1800\")<\/p>\n<p><strong>The count result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4602\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.7-COUNTIF-mutiple-expressions.png\" alt=\"COUNTIF mutiple expressions\" width=\"351\" height=\"411\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.7-COUNTIF-mutiple-expressions.png 351w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.7-COUNTIF-mutiple-expressions-256x300.png 256w\" sizes=\"(max-width: 351px) 100vw, 351px\" \/><\/p>\n<p>You see, the result is 19. First, the formula got 9 based on the first COUNTIF and 10 for the second COUNTIF function. The + is used to sum up the two and so result is 19. If we used \u2018-\u2018 minus, the result would have been -1.<\/p>\n<p>Not the output you expected by giving two expressions? Well, might be you were expecting Month count between 1200 and 1900 rather than the sum of two? If that was the case, see next example.<\/p>\n<h3><strong>Using COUNTIFS for multiple expressions<\/strong><\/h3>\n<p>This should answer your question. The two expressions are given in the <strong>COUNTIFS<\/strong> function to get the count of Months with sales between 1200 (greater than or equal) and less than 1800. Now see the formula and output:<\/p>\n<p class=\"codediv\">=COUNTIFS(B2:B13,\"&gt;=1200\", B2:B13,\"&lt;1800\")<\/p>\n<p><strong>The outcome:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4603\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.8-COUNTIFS-mutiple-expres.png\" alt=\"COUNTIFS mutiple expressions\" width=\"333\" height=\"116\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.8-COUNTIFS-mutiple-expres.png 333w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.8-COUNTIFS-mutiple-expres-300x105.png 300w\" sizes=\"(max-width: 333px) 100vw, 333px\" \/><\/p>\n<p>So, the count is 7 i.e. in between 1200 (inclusive) and 1800 (exclusive).<\/p>\n<h3><strong>Using (*) wildcard example in COUNTIF with blank cells<\/strong><\/h3>\n<p>The (*) wildcard character is used to count cells with any text. The example below shows how to use this. Along with using * as a wildcard, another thing to learn in this example is that a few cells are kept blank to show how COUNTIF treats blank cells.<\/p>\n<p>I have filled the cells from A2 to A11 with fruit and vegetable names. However, the 6,8, and 10 cells are kept blank. The following formula is applied to get the row count with *:<\/p>\n<p class=\"codediv\">=COUNTIF(A2:A11,\"*\")<\/p>\n<p><strong>The result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4604\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.9-COUNTIFS-windcard-asterisk.png\" alt=\"COUNTIFS wildcard asterisk\" width=\"407\" height=\"365\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.9-COUNTIFS-windcard-asterisk.png 407w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.9-COUNTIFS-windcard-asterisk-300x269.png 300w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>You see, * counted all rows with any text while the blank cells are not counted.<\/p>\n<h3><strong>The example of \u2018?\u2019 wildcard<\/strong><\/h3>\n<p>The question mark (?) is also a wildcard that can be used in COUNTIF function. It is used to match the individual character.<\/p>\n<p>This example gets the count of cells where the text has 6 characters and ends at \u201cto\u201d. See how to use the \u2018?\u2019:<\/p>\n<p class=\"codediv\">=COUNTIF(A2:A11,\"????to\")<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4605\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.10-COUNTIFS-windcard-question-mark.png\" alt=\"COUNTIFS winlcard question mark\" width=\"425\" height=\"362\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.10-COUNTIFS-windcard-question-mark.png 425w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.10-COUNTIFS-windcard-question-mark-300x256.png 300w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/p>\n<p>You see, it returned the count as 2 for Tomato and Potato.<\/p>\n<h3><strong>An example of COUNTIF with dates and range names<\/strong><\/h3>\n<p>In all the above examples, I used cell range like A2:10, etc. For this example, two more things are done by using the COUNTIF function.<\/p>\n<p>First, a range name is used. Secondly, the counting is based on dates. For that, employee\u2019s sheet is created that contains Employee Names and their Joining date.<\/p>\n<p>We will get three reports based on that small data. The total number of employees by using the count function. The number of employees who joined after 2008. The third report is the number of employees who joined before or in 2008.<\/p>\n<p>The cells containing data of employees is named <em>empData<\/em> as shown in the graphic below:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4606\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.11-COUNTIFS-range_name.png\" alt=\"COUNTIFS range_name \" width=\"393\" height=\"209\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.11-COUNTIFS-range_name.png 393w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.11-COUNTIFS-range_name-300x160.png 300w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/p>\n<p>Now, I used the following three formulas:<\/p>\n<ul>\n<li><strong>=COUNT(empData)<\/strong> \u2013 to get the total number of employees<\/li>\n<li><strong>=COUNTIF(empData, \"&gt;\" &amp; \"2008-12-31\")<\/strong> \u2013 to get the number of employees joined after 2008<\/li>\n<li><strong>=COUNTIF(empData, \"&lt;=\" &amp; \"2008-12-31\")<\/strong> \u2013 employees joined on or before 2008<\/li>\n<\/ul>\n<p>The results are displayed in the cells B9, B10, and B11 cells as shown below:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4607\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.12-COUNTIFS-date.png\" alt=\"COUNTIFS date\" width=\"588\" height=\"299\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.12-COUNTIFS-date.png 588w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.12-COUNTIFS-date-300x153.png 300w\" sizes=\"(max-width: 588px) 100vw, 588px\" \/><\/p>\n<h3><strong>Getting employee's data between two dates example<\/strong><\/h3>\n<p>Just like in one of the above examples, we got the count of the number of sales between two numbers by using COUNTIFS function. Similarly, you may count between two dates by using COUNTIFS function. Using the same datasheet as in the above example, I will apply the formula to get the count of employees who joined between 2008 to 2012.<\/p>\n<p>The formula:<\/p>\n<p class=\"codediv\">=COUNTIFS(empData,\"&gt;=\"&amp;\"2008-01-01\",empData,\"&lt;=\"&amp;\"2012-12-31\")<\/p>\n<p><strong>The output (notice the last one)<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-4608\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.13-COUNTIFS-date-range.png\" alt=\"COUNTIFS date range\" width=\"486\" height=\"302\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.13-COUNTIFS-date-range.png 486w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.13-COUNTIFS-date-range-300x186.png 300w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.<\/p>\n","protected":false},"author":1,"featured_media":4596,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[142],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v14.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>12 Examples of Excel COUNTIF function to Understand Thoroughly<\/title>\n<meta name=\"description\" content=\"Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"12 Examples of Excel COUNTIF function to Understand Thoroughly\" \/>\n<meta property=\"og:description\" content=\"Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-02T02:07:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-31T19:12:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.1-Excel-COUNTIF.png\" \/>\n\t<meta property=\"og:image:width\" content=\"494\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/11\/6.1-Excel-COUNTIF.png\",\"width\":494,\"height\":369,\"caption\":\"Excel COUNTIF\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/\",\"name\":\"12 Examples of Excel COUNTIF function to Understand Thoroughly\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/#primaryimage\"},\"datePublished\":\"2017-12-02T02:07:52+00:00\",\"dateModified\":\"2023-10-31T19:12:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"Use the Microsoft Excel COUNTIF function (a statistical function) that is used to count the number of cells for the given criterion.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/12-examples-excel-countif-function-understand-thoroughly\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4595"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=4595"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4595\/revisions"}],"predecessor-version":[{"id":9707,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4595\/revisions\/9707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/4596"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=4595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=4595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=4595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}