{"id":103,"date":"2012-10-02T22:59:47","date_gmt":"2012-10-02T14:59:47","guid":{"rendered":"http:\/\/excelchamp.net\/?p=103"},"modified":"2022-07-11T06:27:42","modified_gmt":"2022-07-10T22:27:42","slug":"counting-text-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/","title":{"rendered":"Counting Text Columns like Employee Names in Excel"},"content":{"rendered":"<p>Excel is great and summing things up. And then count the number of rows easily. You can watch the <strong><a title=\"Simple Functions in Excel \u2013 Video\" href=\"http:\/\/excelchamp.net\/simple-functions-in-excel-video\/\" target=\"_blank\" rel=\"noopener noreferrer\">step by step video on how to use simple functions in Excel<\/a><\/strong>.<\/p>\n<p>In fact, most versions of Excel can even show the SUM, COUNT of a block of cells, in the bottom status bar automatically.<\/p>\n<p>However, there is an issue, if you want to count number of employees, or number of departments, or number of students&#8230;<\/p>\n<p><em>Text values, by default can not be summed by the SUM function, and can not be COUNTED by the Count function in Excel<\/em><\/p>\n<p>That&#8217;s because Excel is good at adding and counting numbers, and not Text. If you try, you&#8217;ll get a ZERO.<\/p>\n<p>=COUNT(Employee_Names) will result in a ZERO answer.<\/p>\n<p>Fortunately, the workaround is pretty simple, straight forward and easy to use in Microsoft Excel. And it counts text values with ease.<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>Instead of using the COUNT function, you can use the COUNTA function of Excel. COUNTA is to count Textual data. <\/strong><\/p>\n<p><strong>So if you have characters, alphabets and number combinations (like employee numbers),\u00a0 you can count such text items using the COUNTA function of Excel. <\/strong><\/p>\n<blockquote><p>This COUNTA Function works in all the versions of Excel &#8211; from Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and even Microsoft Office Excel 365 (the cloud version.)<\/p><\/blockquote>\n<p>So to count the number of employees, you only need to say <strong>=COUNTA(A5:A15)<\/strong>.<\/p>\n<p><strong>And this nifty function will count the number of employees promptly. COUNTA is to count Alphanumeric values &#8211; text, strings&#8230; or even numbers.<\/strong><\/p>\n<p>Try it out, and let me know if this helps you&#8230; \ud83d\ude42<\/p>\n<p><strong>You may find these resources useful:<\/strong><\/p>\n<ul>\n<li><a title=\"View All Formulas in Excel with a Single Click\" href=\"http:\/\/excelchamp.net\/view-all-formulas-in-excel-with-a-single-click\/\" target=\"_blank\" rel=\"noopener noreferrer\">View all Formulas in Excel in a Single Click<\/a><\/li>\n<li><a title=\"Creating a Two Axis Chart in Excel 2007 \/ Excel 2010 \/ Excel 2013\" href=\"http:\/\/excelchamp.net\/creating-a-two-axis-chart-in-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Build a Two Axis Chart in Excel<\/a><\/li>\n<\/ul>\n<p>Cheers,<br \/>\nVinai Prakash<br \/>\nFounder of <a title=\"Excel Tips &amp; Tricks\" href=\"http:\/\/excelchamp.net\" target=\"_blank\" rel=\"noopener noreferrer\">ExcelChamp.Net<\/a><\/p>\n<p><strong>\u00a0P.S. &#8211; Are you an Expert in using Excel ? Try solving this &#8211; find a way to <a title=\"How to find duplicates in Excel 2010\" href=\"http:\/\/excelchamp.net\/forums\/topic\/how-to-find-duplicates-in-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\">find duplicates in Excel 2010<\/a> quickly. And post your solution. We are looking for simple and innovative ways to do so&#8230;<\/strong><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<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is great and summing things up. And then count the number of rows easily. You can watch the step by step video on how to use simple functions in Excel. In fact, most versions of Excel can even show the SUM, COUNT of a block of cells, in the bottom status bar automatically. However, &#8230; <a title=\"Counting Text Columns like Employee Names in Excel\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\" aria-label=\"More on Counting Text Columns like Employee Names 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,11],"tags":[23,26],"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 Text Values in Excel<\/title>\n<meta name=\"description\" content=\"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.\" \/>\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\/counting-text-columns-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 Text Values in Excel\" \/>\n<meta property=\"og:description\" content=\"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/counting-text-columns-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=\"2012-10-02T14:59:47+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"Counting Text Columns like Employee Names in Excel\",\"datePublished\":\"2012-10-02T14:59:47+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\"},\"wordCount\":348,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"keywords\":[\"count names\",\"counting textual data\"],\"articleSection\":[\"Excel Functions\",\"Excel In-Built Functionality\",\"Text Functions\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\",\"url\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\",\"name\":\"How To Count Cells With Text Values in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2012-10-02T14:59:47+00:00\",\"dateModified\":\"2022-07-10T22:27:42+00:00\",\"description\":\"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Counting Text Columns like Employee Names 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 Text Values in Excel","description":"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.","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\/counting-text-columns-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How To Count Cells With Text Values in Excel","og_description":"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.","og_url":"https:\/\/www.excelchamp.net\/counting-text-columns-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":"2012-10-02T14:59:47+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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"Counting Text Columns like Employee Names in Excel","datePublished":"2012-10-02T14:59:47+00:00","dateModified":"2022-07-10T22:27:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/"},"wordCount":348,"commentCount":1,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"keywords":["count names","counting textual data"],"articleSection":["Excel Functions","Excel In-Built Functionality","Text Functions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/","url":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/","name":"How To Count Cells With Text Values in Excel","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2012-10-02T14:59:47+00:00","dateModified":"2022-07-10T22:27:42+00:00","description":"counting cells with textual values in Excel is relatively easy with the COUNTA function. Check the steps to count text cells easily in Excel.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/counting-text-columns-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"Counting Text Columns like Employee Names 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\/103"}],"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=103"}],"version-history":[{"count":1,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"predecessor-version":[{"id":1693,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/103\/revisions\/1693"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}