{"id":371047,"date":"2021-11-22T19:00:10","date_gmt":"2021-11-22T16:00:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-count-cells-in-microsoft-excel\/"},"modified":"2021-11-22T19:00:10","modified_gmt":"2021-11-22T16:00:10","slug":"how-to-count-cells-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-count-cells-in-microsoft-excel\/","title":{"rendered":"#How to Count Cells in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2e30ae68b2a\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2e30ae68b2a\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-cells-in-microsoft-excel\/#Count_Cells_With_Numbers_The_COUNT_Function\" >Count Cells With Numbers: The COUNT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-cells-in-microsoft-excel\/#Count_Blank_Cells_The_COUNTBLANK_Function\" >Count Blank Cells: The COUNTBLANK Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-cells-in-microsoft-excel\/#Count_Nonblank_Cells_The_COUNTA_Function\" >Count Nonblank Cells: The COUNTA Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-cells-in-microsoft-excel\/#Count_Cells_With_Specific_Criteria_The_COUNTIF_Function\" >Count Cells With Specific Criteria: The COUNTIF Function<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Count Cells in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel provides various methods for counting cells including using the Find feature or a filter. But with functions, you can count exactly what you need. From filled cells to blanks, from numbers to text, here\u2019s how to count cells in Excel.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Count Colored Cells in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Count_Cells_With_Numbers_The_COUNT_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"moka_anchor_COUNT\">Count Cells With Numbers: The COUNT Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to count the number of cells that contain only numbers, you can use the COUNT function. The syntax for the formula is: <code>COUNT(value1, value2,...)<\/code> where <code>value1<\/code> is required and <code>value2<\/code> is optional.<\/p>\n<p>You\u2019ll use <code>value1<\/code> for your cell references, the range of cells you want to count within. You can use <code>value2<\/code> (and subsequent arguments) to add a particular number or another cell range if you like. Let\u2019s look at a couple of examples.<\/p>\n<p>To count the number of cells in the range A1 through D7 that contains numbers, you would type the following and hit Enter:<\/p>\n<pre>=COUNT(A1:D7)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763150\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountFormula-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNT formula in Excel\" width=\"405\" height=\"260\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You then receive the result in the cell containing the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-763153 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountResult-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNT result\" width=\"460\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To count the number of cells in two separate ranges B2 through B7 and D2 through D7 that contain numbers, you would type the following and press Enter:<\/p>\n<pre>=COUNT(B2:B7,D2:D7)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763151\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountRangesFormula-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNT formula for ranges\" width=\"460\" height=\"260\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now you\u2019ll see the total count of numbers for both of those cell ranges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763152\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountRangesResult-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNT result for ranges\" width=\"500\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Count_Blank_Cells_The_COUNTBLANK_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Count Blank Cells: The COUNTBLANK Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe what you want to find is the number of blank cells you have in a particular range. You\u2019ll use a variation of the COUNT function, COUNTBLANK. The syntax for the formula is: <code>COUNTBLANK(value1)<\/code> where <code>value1<\/code> contains the cell references and is required.<\/p>\n<p>To count the number of blank cells in the range A2 through C11, you would type the following and press Enter:<\/p>\n<pre>=COUNTBLANK(A2:C11)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763155\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountBlankFormula-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTBLANK formula in Excel\" width=\"435\" height=\"350\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see the result in the cell where you entered the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-763154 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountBlankResult-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTBLANK result \" width=\"515\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For additional COUNTBLANK examples and uses, check out our tutorial for <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/760768\/how-to-count-blank-or-empty-cells-in-microsoft-excel\/\">counting blank or empty cells in Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Count_Nonblank_Cells_The_COUNTA_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Count Nonblank Cells: The COUNTA Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Perhaps you\u2019d like to do the exact opposite of counting cells that are blank and instead count cells that contain data. In this case, you would use the COUNTA function. The syntax is <code>COUNTA(value1, value2,...)<\/code> where <code>value1<\/code> is required and <code>value2<\/code> is optional.<\/p>\n<p>Just like <a rel=\"nofollow noopener\" target=\"_blank\" href=\"#moka_anchor_COUNT\">the COUNT function above<\/a>, <code>value1<\/code> is for your cell references and <code>value2<\/code> is for additional ranges you want to include.<\/p>\n<p>To count the number of nonblank cells in the range A2 through C11, you would type the following and hit Enter:<\/p>\n<pre>=COUNTA(A2:C11)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763157\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountAFormula-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTA formula in Excel\" width=\"400\" height=\"360\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As you can see, the COUNTA function counts cells containing any type of data. This includes numbers, text, errors, and empty text or strings. For example, the error in cell C7 is counted.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763156\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountAResult-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTA result\" width=\"475\" height=\"400\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If an error is giving you trouble, it\u2019s easy to hide error values in your spreadsheets.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Count_Cells_With_Specific_Criteria_The_COUNTIF_Function\"><\/span>Count Cells With Specific Criteria: The COUNTIF Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you would like to count the number of cells containing specific data, you would use the COUNTIF function. The syntax for the formula is <code>COUNTIF(value1, criteria)<\/code> where both <code>value1<\/code> and <code>criteria<\/code> are required.<\/p>\n<p>Like the other functions here, <code>value1<\/code> contains the cell references for the range. <code>Criteria<\/code> is the item you want to search for and can be a cell reference, word, number, or wildcard. Let\u2019s look at a couple of basic examples.<\/p>\n<p>To count the number of cells in the range C2 through C6 that contain the word \u201csocks,\u201d you would type the following and press Enter:<\/p>\n<pre>=COUNTIF(C2:C6,\"socks\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763161\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountIfFormulaText-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF text formula in Excel\" width=\"400\" height=\"230\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Notice that if your criterion is a word, you must surround it in double quotes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763160\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountIfResultText-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF text result\" width=\"520\" height=\"275\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To count the number of cells in the range B2 through C6 that contain what\u2019s in cell B2, you would type the following and press Enter:<\/p>\n<pre>=COUNTIF(B2:C6,B2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763158\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountIfFormulaRef-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF cell reference formula in Excel\" width=\"370\" height=\"225\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this case, you would not place the B2 cell reference in double quotes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-763159\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CountIfResultRef-ExcelCountCells.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF cell reference result\" width=\"490\" height=\"275\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For additional COUNTIF examples and uses, take a look at our how-to for <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/752592\/how-to-use-the-countif-formula-in-microsoft-excel\/\">using COUNTIF in Excel.<\/p>\n<p>Counting cells in Microsoft Excel is simple once you know these basic functions and how to use them. But if you\u2019re interested in something like highlighting blanks or errors rather than just counting them, we have you covered!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Highlight Blanks or Errors in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/763146\/how-to-count-cells-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Count Cells in Microsoft Excel&#8221; Excel provides various methods for counting cells including using the Find feature or a filter. But with functions, you can count exactly what you need. From filled cells to blanks, from numbers to text, here\u2019s how to count cells in Excel. RELATED: How to Count Colored Cells in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":371048,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-371047","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/371047","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=371047"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/371047\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/371048"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=371047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=371047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=371047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}