{"id":508692,"date":"2022-11-10T23:00:11","date_gmt":"2022-11-10T20:00:11","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-count-checkboxes-in-microsoft-excel\/"},"modified":"2022-11-10T23:00:11","modified_gmt":"2022-11-10T20:00:11","slug":"how-to-count-checkboxes-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-count-checkboxes-in-microsoft-excel\/","title":{"rendered":"#How to Count Checkboxes in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 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-6af7dfdce51b4\" 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-6af7dfdce51b4\" 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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-checkboxes-in-microsoft-excel\/#%E2%80%9CHow_to_Count_Checkboxes_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Count Checkboxes in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-count-checkboxes-in-microsoft-excel\/#Designate_Cells_for_the_Checkbox_Controls\" >Designate Cells for the Checkbox Controls<\/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-checkboxes-in-microsoft-excel\/#Use_the_COUNTIF_Function\" >Use the COUNTIF 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-checkboxes-in-microsoft-excel\/#Optional_Hide_the_Result_Cells\" >Optional: Hide the Result Cells<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Count_Checkboxes_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Count Checkboxes in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" 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\"\/><\/p>\n<p>First, designate cells to hold &#8220;True&#8221; or &#8220;False&#8221; results based on the state of each checkbox. You can then count up the checkboxes by using Excel&#8217;s COUNTIF function to count the number of &#8220;TRUE&#8221; results.<\/p>\n<p>If you use Excel to create a checklist, you may want to count the number of checked or unchecked boxes. With a simple formula, you can tally them in a cell that adjusts as more boxes are marked or unmarked.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Designate_Cells_for_the_Checkbox_Controls\"><\/span>Designate Cells for the Checkbox Controls<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you check a box in Excel, the result of the check is True. For unchecked boxes, the result is False.<\/p>\n<p>So, before you create the formula to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/794460\/how-to-count-checkboxes-in-google-sheets\/\">count your checkboxes, you\u2019ll need to designate cells to hold the True or False result. You\u2019ll then use that result in your formula.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Count Checkboxes in Google Sheets<\/em><\/strong><\/p>\n<p>Right-click your first checkbox and select \u201cFormat Control\u201d in the shortcut menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835215\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/FormatControl-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Format Control in the shortcut menu\" width=\"366\" height=\"371\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Format Control box that <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears, go to the Control tab. In the Cell Link box, enter the cell where you want to display the True or False result. You can also select the cell in your sheet to populate that box.<\/p>\n<p>Click \u201cOK\u201d to save the change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835214\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/CellLink-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Cell reference in the Cell Link box\" width=\"650\" height=\"387\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Follow the same process for the other checkboxes that you want to count in your sheet.<\/p>\n<p>You should then see the True result for checked boxes and False for unchecked boxes in the designated cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835213\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/CheckedTrue-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Checked boxes displaying True\" width=\"280\" height=\"295\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> If you set the default Value for the checkbox as Unchecked, it won\u2019t display False unless you check the box and then uncheck it.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_COUNTIF_Function\"><\/span>Use the COUNTIF Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once you <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/765958\/how-to-insert-a-checkbox-in-microsoft-excel\/\">have the checkboxes set up, go to the cell where you want to display the count.<\/p>\n<p>You\u2019ll then enter a formula for the COUNTIF function that displays a count for either True or False, depending on which you want to count.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Use the COUNT Function in Microsoft Excel<\/em><\/strong><\/p>\n<p>As an example, we are counting the checked boxes in cells B2 through B11 using their results in cells C2 through C11. So, you\u2019ll use the result cells in your formula as follows:<\/p>\n<pre>=COUNTIF(C2:C11,TRUE)<\/pre>\n<p>You can see that we received the correct count of 6 for our checked boxes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835219\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/COUNTIFTrue-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF True for checked boxes\" width=\"595\" height=\"349\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To count the unchecked boxes instead, simply replace True with False in the formula:<\/p>\n<pre>=COUNTIF(C2:C11,FALSE)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835218\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/COUNTIFFalse-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF False for unchecked boxes\" width=\"595\" height=\"349\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> If you set the default Value for the checkbox as Mixed, it will not count toward the True or False result. It displays as #N\/A until the box is checked or unchecked.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Optional_Hide_the_Result_Cells\"><\/span>Optional: Hide the Result Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It may not be ideal to display the True and False results in your sheet. It might be distracting from the data you want to see.<\/p>\n<p>If you have the results in a single column or row without any other data you need, you can simply <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/218582\/how-to-hide-cells-rows-and-columns-in-excel\/\">hide the column or row.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Hide Cells, Rows, and Columns in Excel<\/em><\/strong><\/p>\n<p>Right-click the column or row and pick \u201cHide\u201d in the shortcut menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835217\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/HideColumn-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Hide in the column menu\" width=\"512\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The formula for the checked or unchecked boxes will work just the same with the results hidden.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-835216\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/09\/HiddenColumn-ExcelCountCheckboxes.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Results column hidden in Excel\" width=\"525\" height=\"300\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Counting the number of completed tasks, incomplete orders, or something similar is easy to do with the COUNTIF function and a bit of checkbox manipulation in Excel.<\/p>\n<p>For more, check out how to use checkboxes in your Word documents too.<\/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\/835206\/how-to-count-checkboxes-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Count Checkboxes in Microsoft Excel&#8221; First, designate cells to hold &#8220;True&#8221; or &#8220;False&#8221; results based on the state of each checkbox. You can then count up the checkboxes by using Excel&#8217;s COUNTIF function to count the number of &#8220;TRUE&#8221; results. If you use Excel to create a checklist, you may want to count&#8230;<\/p>\n","protected":false},"author":1,"featured_media":508693,"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-508692","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\/508692","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=508692"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/508692\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/508693"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=508692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=508692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=508692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}