{"id":573,"date":"2023-10-23T00:01:03","date_gmt":"2023-10-23T00:01:03","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/"},"modified":"2023-12-25T10:32:03","modified_gmt":"2023-12-25T10:32:03","slug":"contar-contra-contar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/","title":{"rendered":"\u00bfcu\u00e1l es la diferencia entre contar y contar?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2076911008\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, hay dos funciones de uso frecuente CONTAR y CONTAR. Ambas funciones funcionan igual, pero hay una gran diferencia en que es necesario saber c\u00f3mo utilizarlas de manera \u00f3ptima.<\/p>\n<ul>\n<li> <strong>CONTAR<\/strong> : Esta funci\u00f3n cuenta las celdas donde tiene un n\u00famero como valor en la celda. Por ejemplo, si tiene 5 celdas en el rango A1:A10 con valores num\u00e9ricos, COUNT devolver\u00e1 5 en el resultado.<\/li>\n<li> <strong>CONTAR<\/strong> : Esta funci\u00f3n cuenta las celdas donde tiene valores, es decir, celdas que no est\u00e1n en blanco o en blanco. Por ejemplo, si tiene 7 celdas en el rango A1:A10 con valores, devolver\u00e1 7 en el resultado. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70604\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\" sizes=\"auto, \" srcset=\"\" alt=\"cuenta-contra-cuenta\" width=\"480\" height=\"331\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Ejemplo para entender la diferencia (COUNT Vs. COUNTA)<\/h2>\n<p> En el siguiente ejemplo, tenemos una lista de valores en la columna A donde tenemos diferentes tipos de valores, incluidos n\u00fameros, texto, s\u00edmbolos y valores vac\u00edos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70605\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cellules-avec-des-valeurs-differentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"celdas-con-valores-diferentes\" width=\"330\" height=\"427\"><\/figure>\n<\/div>\n<p> Ahora, cuando usas la funci\u00f3n CONTAR, devuelve 3 en el resultado porque solo tienes tres valores de 9 que son n\u00fameros. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70606\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-la-formule-de-comptage.png\" sizes=\"auto, \" srcset=\"\" alt=\"Usa la f\u00f3rmula de conteo.\" width=\"417\" height=\"403\"><\/figure>\n<\/div>\n<p> Pero cuando usas la funci\u00f3n CONTAR para el mismo rango, devuelve 9 en el resultado porque tenemos 9 celdas con el valor en el rango. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-la-formule-counta.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar-counta-f\u00f3rmula\" width=\"381\" height=\"390\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> \u00bfQu\u00e9 funci\u00f3n es mejor entre estas dos?<\/h2>\n<p> Ambas funciones son \u00fatiles y f\u00e1ciles de usar, pero, en un escenario del mundo real, CONTAR tiene m\u00e1s sentido ya que puede ayudarle a contar celdas con valores m\u00e1s frecuentes que contar celdas con n\u00fameros. Pero eso no hace que la funci\u00f3n CONTAR sea menos \u00fatil, las personas que analizan datos usan mucho la funci\u00f3n CONTAR.<\/p>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-celdas-con-texto\/\">Contar celdas con texto en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-caracteres-especificos\/\">Contar caracteres espec\u00edficos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/\">Cuente el n\u00famero total de celdas en un rango en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-valores-unicos-1\/\">Contar valores \u00fanicos en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, hay dos funciones de uso frecuente CONTAR y CONTAR. Ambas funciones funcionan igual, pero hay una gran diferencia en que es necesario saber c\u00f3mo utilizarlas de manera \u00f3ptima. CONTAR : Esta funci\u00f3n cuenta las celdas donde tiene un n\u00famero como valor en la celda. Por ejemplo, si tiene 5 celdas en el rango [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-573","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfcu\u00e1l es la diferencia entre contar y contar?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfcu\u00e1l es la diferencia entre contar y contar?\" \/>\n<meta property=\"og:description\" content=\"En Excel, hay dos funciones de uso frecuente CONTAR y CONTAR. Ambas funciones funcionan igual, pero hay una gran diferencia en que es necesario saber c\u00f3mo utilizarlas de manera \u00f3ptima. CONTAR : Esta funci\u00f3n cuenta las celdas donde tiene un n\u00famero como valor en la celda. Por ejemplo, si tiene 5 celdas en el rango [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\",\"name\":\"\u00bfcu\u00e1l es la diferencia entre contar y contar?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"datePublished\":\"2023-10-23T00:01:03+00:00\",\"dateModified\":\"2023-12-25T10:32:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfcu\u00e1l es la diferencia entre contar y contar?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfcu\u00e1l es la diferencia entre contar y contar?","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:\/\/exceladvisor.org\/es\/contar-contra-contar\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfcu\u00e1l es la diferencia entre contar y contar?","og_description":"En Excel, hay dos funciones de uso frecuente CONTAR y CONTAR. Ambas funciones funcionan igual, pero hay una gran diferencia en que es necesario saber c\u00f3mo utilizarlas de manera \u00f3ptima. CONTAR : Esta funci\u00f3n cuenta las celdas donde tiene un n\u00famero como valor en la celda. Por ejemplo, si tiene 5 celdas en el rango [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:03+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/","url":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/","name":"\u00bfcu\u00e1l es la diferencia entre contar y contar?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","datePublished":"2023-10-23T00:01:03+00:00","dateModified":"2023-12-25T10:32:03+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/contar-contra-contar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-compte-contre-comptea.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfcu\u00e1l es la diferencia entre contar y contar?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=573"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/573\/revisions"}],"predecessor-version":[{"id":1396,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/573\/revisions\/1396"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}