{"id":2836,"date":"2020-12-22T16:28:11","date_gmt":"2020-12-23T00:28:11","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=2836"},"modified":"2020-12-22T16:29:06","modified_gmt":"2020-12-23T00:29:06","slug":"how-to-use-countif-in-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=2836","title":{"rendered":"How to Use COUNTIF in Excel"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\">Use the COUNTIF function to make Excel count words or numbers in any range of cells.<\/h5>\n\n\n\n<p>Instead of manually counting how often a certain value or number appears, let Excel do the work for you. With the COUNTIF function, Excel can count the number of times a word or number appears in any range of cells.<\/p>\n\n\n\n<p>For example, let&#8217;s say I want to count the number of times the word &#8220;Gryffindor&#8221; appears in my data set.<\/p>\n\n\n\n<p>The formula:&nbsp;<strong>=COUNTIF(range, criteria)<\/strong><\/p>\n\n\n\n<p>The formula with variables from our example below:&nbsp;<strong>=COUNTIF(D:D,&#8221;Gryffindor&#8221;)<\/strong><\/p>\n\n\n\n<p>In this formula, there are several variables:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Range:<\/strong>&nbsp;The range that we want the formula to cover. In this case, since we&#8217;re only focusing on one column, we use &#8220;D:D&#8221; to indicate that the first and last column are both D. If I were looking at columns C and D, I would use &#8220;C:D.&#8221;<\/li><li><strong>Criteria:&nbsp;<\/strong>Whatever number or piece of text you want Excel to count. Only use quotation marks if you want the result to be text instead of a number. In our example, the criteria is &#8220;Gryffindor.&#8221;<\/li><\/ul>\n\n\n\n<p>Simply typing in the COUNTIF formula in any cell and pressing &#8220;Enter&#8221; will show me how many times the word &#8220;Gryffindor&#8221; appears in the dataset.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/blog.hubspot.com\/hs-fs\/hub\/53\/file-2418285161-gif\/COUNTIF_GIF.gif?width=600&amp;name=COUNTIF_GIF.gif\" alt=\"COUNTIF formula in Excel\" title=\"COUNTIF\"\/><\/figure>\n\n\n\n<p>Ref: https:\/\/blog.hubspot.com\/marketing\/how-to-use-excel-tips<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the COUNTIF function to make Excel count words or numbers in any range of cells. Instead of manually counting how often a certain value or number appears, let Excel do the work for you. With the COUNTIF function, Excel can count the number of times a word or number appears in any range of <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=2836\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[518],"class_list":["post-2836","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-countif"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2836","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2836"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2836\/revisions"}],"predecessor-version":[{"id":2837,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/2836\/revisions\/2837"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}