{"id":3595,"date":"2020-12-17T10:39:00","date_gmt":"2020-12-17T09:39:00","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3595"},"modified":"2020-12-17T10:39:00","modified_gmt":"2020-12-17T09:39:00","slug":"counta-formula-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-formulas\/counta-formula-google-sheets\/","title":{"rendered":"Comment utiliser la fonction COUNTA dans Google Sheets ?"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>The <a href=\"https:\/\/support.google.com\/docs\/answer\/3093991?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">COUNTA<\/a> function in Google Sheets is a simple and widely-used function for everyday spreadsheet work. It quickly gives you the <strong>total number of values<\/strong> within a specific range of cells. Whereas the <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/count-formula-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">COUNT<\/a> function only counts cells containing numbers, the COUNTA function counts how many cells in the dataset contain <strong>any kind of data<\/strong>. That includes numerical values, text (including white space and zero-length strings), logical expressions, error messages, dates and formulas.<\/p>\n<p>Repeated values are also counted. Blank or empty cells are excluded.<\/p>[\/et_pb_text][et_pb_text admin_label=&#8221;Connections T &#8211; Automate between spreadsheets &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; global_module=&#8221;50460&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\" width=\"250\" height=\"168\" alt=\"\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/><\/p>\n<p><span style=\"font-size: 22px; font-weight: 600;\">Automate data transfers between spreadsheets<br \/><\/span><\/p>\n<p><a href=\"https:\/\/www.sheetgo.com\/connections\/\" target=\"_blank\" rel=\"noopener\">Find out how<\/a><\/p>\n[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>Syntax<\/h2>[\/et_pb_text][et_pb_text module_class=&#8221;spreadsheet-function&#8221; _builder_version=&#8221;4.16&#8243; border_width_left=&#8221;4px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]=COUNTA(value1, [value2, \u2026])[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<ul>\n<li><strong>value1<\/strong> \u2013 the value or range of cell(s) to count within.<\/li>\n<li><strong>value2, value3<\/strong>\u00a0&#8230;\u00a0\u2013 (optional, up to 30) additional values to also be included in the count.<\/li>\n<\/ul>\n<p>The value arguments can be:<\/p>\n<ul>\n<li>A value<\/li>\n<li>A cell reference<\/li>\n<li>A range of cells<\/li>\n<li>A named range<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<span style=\"color: #1c272c; font-family: Proxima-Nova-Black, Helvetica, Arial, Lucida, sans-serif; font-size: 42px;\">How to use COUNTA function<\/span>\n<p>I will show the function in action with a few examples:<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/CountA-image-1-1.png&#8221; alt=&#8221;counta-function-google-sheets-1&#8243; title_text=&#8221;counta-function-google-sheets-1&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>You can see that the input parameters can take many forms: a number, text within double quotes, and a reference to a range of cells The most basic form of the function uses a range as an input with the formula <strong>=CountA(B2:B9)<\/strong>.<\/p>\n<p>No matter what kind of combination you use for the input parameters, the COUNTA function does its job of counting the values. In all of these cases from row 2 through to 7, the function returned the result 8, as there are 8 different values in the third column (including the \u201cFailed\u201d ones). Therefore, you can see that the function counts both numbers and text values.<\/p>\n<p>I included two column ranges in the case in row 8, hence the result was 16. But in the final example, you will see that the output returned is 3, while the data set consists of values from 4 cells: A9, A10, B9 and B10. This difference is because the COUNTA function doesn\u2019t count blank values<\/p>\n<p>COUNTA function also counts other types of data:<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/CountA-image-2-1.png&#8221; alt=&#8221;counta-function-google-sheets-2&#8243; title_text=&#8221;counta-function-google-sheets-2&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>In the example above, I entered various arbitrary values like a date, currency, percentage, decimal, and general text and even special characters. I also validated for blank values on the second column, using the ISBLANK function. So, all the values in rows 2 through to 9 (barring row 8) are non-blank values. Not surprisingly, the COUNTA function in column C counted all the non-blank values, and gives a total count of 7.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>COUNTA vs. COUNT<\/h3>\n<p>The COUNT function in Google Sheets is similar to COUNTA, except COUNT only counts numbers, whereas COUNTA counts all values. The example below highlights the difference between the two.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/CountA-image-3-1-1.png&#8221; alt=&#8221;counta-function-google-sheets-3&#8243; title_text=&#8221;counta-function-google-sheets-3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Here I use both functions on the same set of data from the first example. You can see that the COUNTA function counts both the numerical values, and the text values for the students that failed. The COUNT function, on the other hand, only counts the numerical values and ignores the text values. Neither function counts the blank cell for Ivan\u2019s test score.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>Blank cells<\/h3>\n<p>By now you understand that the COUNTA function counts all cells that contain a value, and ignores any cell that is blank. However, there are some tricky cases where a cell can appear blank but actually has a value and is included in the count. The example below illustrates this.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/12\/CountA-image-4-1.png&#8221; alt=&#8221;counta-function-google-sheets-4&#8243; title_text=&#8221;counta-function-google-sheets-4&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>At first glance, it looks like the first three cells in the list are all blank. However, from the Is Blank? column, you can see that only the second cell is truly blank. The others are an empty string, and an apostrophe, both of which appear to be blank but are not. When you use the COUNTA function, these cells are counted \u2013 so keep this in mind when using the function!<\/p>\n<p>Want to count how many unique values appear in a range? Use Google Sheets <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/countunique-formula-in-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">COUNTUNIQUE function<\/a> instead.\u00a0<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f9f9ff&#8221; custom_margin=&#8221;40px||40px||false|false&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><em><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Connections B &#8211; Importrange alternative &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;50475&#8243; theme_builder_area=&#8221;post_content&#8221;]<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\" width=\"250\" height=\"168\" alt=\"\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/><\/p>\n<p><span style=\"font-size: 22px; font-weight: 600;\">An importrange alternative, more efficient and easier to manage<\/span><\/p>\n<p><a href=\"https:\/\/workspace.google.com\/marketplace\/app\/sheetgo\/94172092257\" target=\"_blank\" rel=\"noopener\"><br \/><img decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/available-on-google-workspace-button-text.webp\" width=\"180\" height=\"\" alt=\"\" \/><br \/><\/a><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>The COUNTA function in Google Sheets is a simple and widely-used function for everyday spreadsheet work. It quickly gives you the total number of values within a specific range of cells. Whereas the COUNT function only counts cells containing numbers, the COUNTA function counts how many cells in the dataset contain any kind of data. [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":29453,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets, like the COUNT formula, the <a href=\"https:\/\/support.google.com\/docs\/answer\/3093991?hl=en\">COUNTA<\/a> formula is yet another simpler and one of the most widely used formulas for day to day spreadsheet needs. It gives us the total number of values within the specified data set.\n<h3>Syntax<\/h3>\n<strong><span style=\"font-family: courier new,courier,monospace; font-size: 14pt;\">COUNTA(value1, [value2, ...])<\/span><\/strong>\n<ul>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>value1<\/strong><\/span> - is the value or reference to a range of cell(s) to consider while counting.<\/li>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>value2<\/strong><\/span> - and above are optional and additional values or ranges to consider for counting.<\/li>\n<\/ul>\n<h4>Usage: COUNTA Formula<\/h4>\nWe will try and explain the syntax with a few examples below - as it helps strengthen our understanding.\n\n<img class=\"aligncenter size-full wp-image-3607\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/counta1.png\" alt=\"COUNTA Formula - Illustration 1\" width=\"699\" height=\"292\" \/>\n\nFrom the list of cases illustrated above, we can deduce that the input parameters can take any of the following forms. It can be a number, text within double quotes, and reference to a range of cells.\n\nNo matter what kind of combination we use for the input parameters, the COUNTA formula does its job of counting the values. In all of these cases from row 2 through to 7, the formula returned the result 8, as there are 8 different values in the third column (including the \"Failed\" ones). Therefore, we can establish that the formula is counting both the numbers and text values.\n\nWe included two column ranges in the case on row 8, hence the result showed up as 16. But in the final example, we see the output returned is 3, while the data set consists of values from cells A9, A10, B9 and B10. This difference is because, the COUNTA formula doesn't count blank values!\n\nLet us see what other things the COUNTA formula counts.\n\n<img class=\"aligncenter size-full wp-image-3608\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/counta2.png\" alt=\"COUNTA Formula - Illustration 2\" width=\"549\" height=\"267\" \/>\n\nIn the above image, we have put in various arbitrary values like a date, currency, percentage, decimal, and general text and even special characters. Accordingly, we have validated for blank values on the second column, using the ISBLANK formula. So, all the values on the rows 2 through to 9 barring row 8 are non blank values. And, not surprisingly, the COUNTA formula on the column C counted only the non blank values.\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[55,39,28],"class_list":["post-3595","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/3595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=3595"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/3595\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/29453"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=3595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=3595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=3595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}