{"id":84,"date":"2023-11-17T07:02:42","date_gmt":"2023-11-17T07:02:42","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/"},"modified":"2023-12-25T10:24:39","modified_gmt":"2023-12-25T10:24:39","slug":"contar-el-numero-total-de-celulas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/","title":{"rendered":"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-455773700\"><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, puede usar dos f\u00f3rmulas diferentes si desea contar la cantidad de celdas en un rango (celdas en blanco y no en blanco). En este tutorial, veremos ambas f\u00f3rmulas.<\/p>\n<h2 class=\"wp-block-heading\"> Cuente el n\u00famero de celdas (M\u00e9todo-1)<\/h2>\n<p> En el siguiente ejemplo, tenemos algunos valores en la columna A y necesitas contar las celdas en el rango A1:B10. Y para ello vamos a utilizar las funciones FILAS y COLUMNAS.<\/p>\n<p> Pasos para escribir la f\u00f3rmula:<\/p>\n<ol type=\"1\">\n<li> Primero, en la celda D1, ingrese \u00bb <code>=ROWS (A1:B10)<\/code> \u00ab.<\/li>\n<li> Luego, escriba el signo de asterisco (*) para multiplicar los valores.<\/li>\n<li> Despu\u00e9s de eso, debe ingresar la funci\u00f3n COLUMNA refiri\u00e9ndose al mismo rango (COLUMNAS (A1: B10).<\/li>\n<li> Al final, presione el bot\u00f3n Enter para mostrar el resultado en la celda. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66794\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n de filas y columnas\" width=\"445\" height=\"273\"><\/figure>\n<\/div>\n<p> Ahora, como puede ver, cuando presiona Enter, devuelve 20 en el resultado porque tiene un total de 20 celdas en el rango que especific\u00f3. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66795\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Resultat-de-comptage-de-2-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultado del recuento de c\u00e9lulas\" width=\"496\" height=\"303\"><\/figure>\n<\/div>\n<p> Ahora intentemos entender la f\u00f3rmula que usamos aqu\u00ed. En la primera parte, utilizamos la funci\u00f3n FILAS que devuelve el n\u00famero de filas que tiene en un rango. Aqu\u00ed devuelve 10 porque tienes diez filas en el rango A1 a B10. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66796\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-3-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula de l\u00edneas\" width=\"471\" height=\"332\"><\/figure>\n<\/div>\n<p> Ahora, la pr\u00f3xima vez tendr\u00e1 la funci\u00f3n COLUMNAS que devuelve el n\u00famero de columnas que tiene en un rango. Aqu\u00ed devuelve 2 porque tiene dos columnas en el rango A1 a B10. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66797\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-4-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"columnas de f\u00f3rmula\" width=\"421\" height=\"286\"><\/figure>\n<\/div>\n<p> Al final tienes un asterisco entre los dos valores para multiplicar las filas y columnas y obtener el n\u00famero total de celdas del rango.<\/p>\n<h2 class=\"wp-block-heading\"> Combina CONTAR \u2013 CONTAR EN BLANCO para contar celdas en un rango<\/h2>\n<p> El segundo m\u00e9todo requiere que combine las funciones CONTAR y CONTAR EN BLANCO. Al combinar las dos funciones, puede contar todas las celdas que no est\u00e1n en blanco y todas las celdas en blanco en un rango. A continuaci\u00f3n tenemos el mismo ejemplo que usamos en el primer ejemplo.<\/p>\n<p> En la celda D1, puede ingresar la siguiente f\u00f3rmula: <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTA(A1:B10)+COUNTBLANK(A1:B10)<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66798\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-counta-countblank-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-contar-contar-en-blancos\" width=\"546\" height=\"280\"><\/figure>\n<\/div>\n<p> Como dije, esta f\u00f3rmula funciona en dos partes:<\/p>\n<ol type=\"1\">\n<li> La funci\u00f3n CONTARA cuenta las celdas donde tiene valores.<\/li>\n<li> La funci\u00f3n CONTAR EN BLANCO cuenta las celdas donde no tiene valores.<\/li>\n<\/ol>\n<p> En \u00faltima instancia, tiene un \u00absigno +\u00bb que suma los dos n\u00fameros y le devuelve el n\u00famero total de celdas que tiene en el rango que especific\u00f3. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-les-cellules-dune-plage.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\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-valores-unicos-1\/\">Contar valores \u00fanicos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-contra-contar\/\">CONTAR Vs. CONTARA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-las-palabras\/\">Contar palabras en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, puede usar dos f\u00f3rmulas diferentes si desea contar la cantidad de celdas en un rango (celdas en blanco y no en blanco). En este tutorial, veremos ambas f\u00f3rmulas. Cuente el n\u00famero de celdas (M\u00e9todo-1) En el siguiente ejemplo, tenemos algunos valores en la columna A y necesitas contar las 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-84","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>\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?<\/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-el-numero-total-de-celulas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?\" \/>\n<meta property=\"og:description\" content=\"En Excel, puede usar dos f\u00f3rmulas diferentes si desea contar la cantidad de celdas en un rango (celdas en blanco y no en blanco). En este tutorial, veremos ambas f\u00f3rmulas. Cuente el n\u00famero de celdas (M\u00e9todo-1) En el siguiente ejemplo, tenemos algunos valores en la columna A y necesitas contar las celdas en el rango [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/\",\"name\":\"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"datePublished\":\"2023-11-17T07:02:42+00:00\",\"dateModified\":\"2023-12-25T10:24:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?\"}]},{\"@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":"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?","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-el-numero-total-de-celulas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?","og_description":"En Excel, puede usar dos f\u00f3rmulas diferentes si desea contar la cantidad de celdas en un rango (celdas en blanco y no en blanco). En este tutorial, veremos ambas f\u00f3rmulas. Cuente el n\u00famero de celdas (M\u00e9todo-1) En el siguiente ejemplo, tenemos algunos valores en la columna A y necesitas contar las celdas en el rango [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:39+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/","url":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/","name":"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","datePublished":"2023-11-17T07:02:42+00:00","dateModified":"2023-12-25T10:24:39+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fonction-lignes-et-colonnes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/contar-el-numero-total-de-celulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo contar el n\u00famero total de celdas en un rango?"}]},{"@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\/84","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=84"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/84\/revisions"}],"predecessor-version":[{"id":943,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/84\/revisions\/943"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}