{"id":135,"date":"2013-12-18T21:57:53","date_gmt":"2013-12-18T13:57:53","guid":{"rendered":"http:\/\/excelchamp.net\/?p=135"},"modified":"2022-07-11T06:27:42","modified_gmt":"2022-07-10T22:27:42","slug":"how-to-count-cells-with-a-certain-value-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/","title":{"rendered":"How To Count Cells With a Certain Value in Excel"},"content":{"rendered":"<p>There are several instances when you need to count the number of cells that contain a certain value.<\/p>\n<p>For example, you want to:<\/p>\n<ul>\n<li><em>Count if a product code is duplicated or not<\/em><\/li>\n<li><em>Count the existence of a text string in a given range of cells<\/em><\/li>\n<\/ul>\n<p>To do this, there are several different ways in Microsoft Excel.<\/p>\n<p><strong>Method 1: Use Sum &amp; If Functions in Excel<\/strong><\/p>\n<p><strong><em>=SUM( IF(range=&#8221;text&#8221;, 1, 0))<\/em><\/strong><\/p>\n<p>Note that this is an array formula, meaning that it must be keyed in a special way. Do not simply press Enter key to finish typing this formula. You must press CTRL + SHIFT + ENTER together.<\/p>\n<p>Once you key in the array formula, it looks like below ( this formula searches for the value of 5 inn the cell ranging from A1 to C3. If it finds a 5, it counts a 1. All the counts are then Summed Up.)<\/p>\n<p><em><strong>=SUM( IF( A1:C3 = 5, 1, 0) )<\/strong> <\/em><br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"705\" class=\"elementor elementor-705 elementor-bc-flex-widget\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7f5e9af elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7f5e9af\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f6d494f\" data-id=\"f6d494f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db6834f elementor-widget elementor-widget-text-editor\" data-id=\"db6834f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div style=\"background-color: #ffffcc; color: black; border: thin Black; border-style: none; align = center; line-height: 27px; width: 95%; padding: 20px 30px 10px;\"><p style=\"text-align: center;\"><span style=\"color: #0000cd;\"><strong>Want to Improve Your Excel Skills?<\/strong><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">Learn the Key Features of Excel Quickly &amp; Easily, by <\/span><span style=\"color: #0000cd;\">Joining the<br \/> <a href=\"https:\/\/www.trueducate.com\/courses\/basic-excel-online\/\" target=\"_blank\" rel=\"noopener\"><u><strong>Online Training<\/strong> on <\/u><strong><u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #0000cd;\">To Get Most out of Excel, Learn the\u00a0 <b><u><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Pivot Table techniques in our<br \/> Pivot Table Masterclass Training<\/a><\/u><\/b><a href=\"https:\/\/www.trueducate.com\/courses\/excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\"><strong>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<br \/>\n<strong>Method 2: Use the inbuilt Countif Function of Excel<\/strong><\/p>\n<p><em><strong>\u00a0=COUNTIF(A1:C3, &#8220;text&#8221;)<\/strong><\/em><\/p>\n<p>Note that this is a simple and straight forward way. It is not considered an Array function. Just key it in, and press the Enter key.<\/p>\n<p>Voila, it shows you the correct count.<\/p>\n<p><strong>There you are! Two Simple ways to count the number of occurrences of a value in a range of cells in Excel. <\/strong><\/p>\n<p><strong>These above 2 methods work in all versions of Excel, on the PC and on the Mac.<\/strong><\/p>\n<p>Hope you will benefit from them!<\/p>\n<p>Cheers,<br \/>\nVinai Prakash<br \/>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"514\" class=\"elementor elementor-514\" data-elementor-post-type=\"elementor_library\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-14e69bc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"14e69bc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31f6f1ef\" data-id=\"31f6f1ef\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b580a03 elementor-widget elementor-widget-heading\" data-id=\"3b580a03\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Are you facing any problem in using Excel?  Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2709bfb elementor-widget elementor-widget-text-editor\" data-id=\"2709bfb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #ff9900;\"><span class=\"st\">You have come to the right place<\/span>. Tell us your needs. We&#8217;ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e758d36 elementor-button-align-center elementor-widget elementor-widget-form\" data-id=\"6e758d36\" data-element_type=\"widget\" data-settings=\"{&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Quick Enquiry\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"514\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"6e758d36\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"ExcelChamp\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-field_1 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_1\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tName\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[field_1]\" id=\"form-field-field_1\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Name\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-field_2 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_2\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[field_2]\" id=\"form-field-field_2\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Email\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-textarea elementor-field-group elementor-column elementor-field-group-field_3 elementor-col-100 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-field_3\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tQuestion\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t<textarea class=\"elementor-field-textual elementor-field  elementor-size-sm\" name=\"form_fields[field_3]\" id=\"form-field-field_3\" rows=\"3\" placeholder=\"Question\" required=\"required\" aria-required=\"true\"><\/textarea>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_9c3764f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_9c3764f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6Let3GkeAAAAABfVEzbSL0GVAq2ejuG2VI3tGriG\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-100 e-form__buttons\">\n\t\t\t\t\t<button type=\"submit\" class=\"elementor-button elementor-size-sm elementor-animation-grow\">\n\t\t\t\t\t\t<span >\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-align-icon-right elementor-button-icon\">\n\t\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-arrow-right\"><\/i>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Help Me Out<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t<br \/>\nVinai conducts workshops to enable all Excel enthusiasts in learning simple tips, tricks, techniques in Excel. Join a 2 day workshop in Singapore, or email us the city where you want to have the workshop conducted. We can<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are several instances when you need to count the number of cells that contain a certain value. For example, you want to: Count if a product code is duplicated or not Count the existence of a text string in a given range of cells To do this, there are several different ways in Microsoft &#8230; <a title=\"How To Count Cells With a Certain Value in Excel\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\" aria-label=\"More on How To Count Cells With a Certain Value in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[5,6],"tags":[24,25,60,90],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Count Cells With a Certain Value in Excel<\/title>\n<meta name=\"description\" content=\"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Count Cells With a Certain Value in Excel\" \/>\n<meta property=\"og:description\" content=\"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-18T13:57:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-10T22:27:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"331\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"How To Count Cells With a Certain Value in Excel\",\"datePublished\":\"2013-12-18T13:57:53+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\"},\"wordCount\":290,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"countif\",\"counting cells with a particular value in Excel\",\"if\",\"sum\"],\"articleSection\":[\"Excel Functions\",\"Excel In-Built Functionality\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\",\"url\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\",\"name\":\"How to Count Cells With a Certain Value in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2013-12-18T13:57:53+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"description\":\"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Count Cells With a Certain Value in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Count Cells With a Certain Value in Excel","description":"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Count Cells With a Certain Value in Excel","og_description":"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.","og_url":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2013-12-18T13:57:53+00:00","article_modified_time":"2022-07-10T22:27:42+00:00","og_image":[{"width":331,"height":314,"url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1","type":"image\/png"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"How To Count Cells With a Certain Value in Excel","datePublished":"2013-12-18T13:57:53+00:00","dateModified":"2022-07-10T22:27:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/"},"wordCount":290,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["countif","counting cells with a particular value in Excel","if","sum"],"articleSection":["Excel Functions","Excel In-Built Functionality"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/","url":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/","name":"How to Count Cells With a Certain Value in Excel","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2013-12-18T13:57:53+00:00","dateModified":"2022-07-10T22:27:42+00:00","description":"Counting cells that have a particular value in Excel 2010 is a simple matter with these simple methods. Use the combination functions provided by ExcelChamp Vinai Prakash.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/how-to-count-cells-with-a-certain-value-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"How To Count Cells With a Certain Value in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/135"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":1,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":1691,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/135\/revisions\/1691"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}