{"id":82,"date":"2023-11-17T07:33:43","date_gmt":"2023-11-17T07:33:43","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/"},"modified":"2023-12-25T10:24:37","modified_gmt":"2023-12-25T10:24:37","slug":"numero-de-celdas-vacias","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/","title":{"rendered":"\u00bfc\u00f3mo contar celdas en blanco en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2998508606\"><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>Si desea contar celdas en blanco en Excel, puede usar la funci\u00f3n CONTAR EN BLANCO que est\u00e1 especialmente dise\u00f1ada para contar celdas en blanco (sin ning\u00fan valor). En la funci\u00f3n CONTAR EN BLANCO, s\u00f3lo necesita hacer referencia al rango desde el cual desea contar las celdas en blanco.<\/p>\n<h2 class=\"wp-block-heading\"> Utilice la funci\u00f3n CONTAR EN BLANCO<\/h2>\n<p> En el siguiente ejemplo, tiene algunos valores en el rango A1:A10, pero algunas celdas est\u00e1n vac\u00edas. Y ahora necesitas contar las celdas que no contienen ning\u00fan valor. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67105\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"playa-con-celdas-vacias\" width=\"354\" height=\"315\"><\/figure>\n<\/div>\n<p> Puede utilizar los siguientes pasos para escribir esta f\u00f3rmula:<\/p>\n<ol>\n<li> Primero, en la celda B1, comience a escribir la funci\u00f3n CONTAR EN BLANCO (=CONTAR EN BLANCO).<\/li>\n<li> Despu\u00e9s de eso, escriba los par\u00e9ntesis iniciales.<\/li>\n<li> Ahora consulte el rango A1:A10 en la funci\u00f3n.<\/li>\n<li> Al final, escriba un par\u00e9ntesis de cierre y presione Entrar. <\/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-67106\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-a-2-chiffres.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula de contar en blanco\" width=\"410\" height=\"314\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=COUNTBLANK(A1:A10)<\/code><\/pre>\n<p> Una vez que presiona Enter, devuelve el n\u00famero de celdas vac\u00edas en el rango especificado. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67107\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeur-de-resultat-a-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor-resultado-en-blanco\" width=\"424\" height=\"320\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Usando CONTAR.SI para contar celdas vac\u00edas<\/h2>\n<p> Tambi\u00e9n puedes usar CONTAR.SI y crear una condici\u00f3n para contar celdas vac\u00edas. Usando el mismo ejemplo, puede seguir los pasos a continuaci\u00f3n para escribir esta f\u00f3rmula:<\/p>\n<ol type=\"1\">\n<li> Primero, en la celda B1, comience a escribir la funci\u00f3n CONTAR.SI (=CONTAR.SI) e ingrese un par\u00e9ntesis inicial.<\/li>\n<li> Ahora consulte el rango A1:A10 desde donde desea contar las celdas sin valores.<\/li>\n<li> Luego, en el argumento de criterios, escriba \u00ab=\u00bb. Este operador igual le dice a Excel que cuente las celdas donde no tiene valor porque con el operador = no ha especificado nada.<\/li>\n<li> Despu\u00e9s de eso, escriba el par\u00e9ntesis de cierre y presione Entrar. <\/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-67108\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-countif-pour-compter-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar para contar celdas vac\u00edas\" width=\"436\" height=\"312\"><\/figure>\n<\/div>\n<p> Y en el momento en que presionas Enter, te devuelve el n\u00famero de celdas vac\u00edas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67109\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comptes-pour-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"contar para celdas vac\u00edas\" width=\"466\" height=\"328\"><\/figure>\n<\/div>\n<p> Tambi\u00e9n puedes utilizar una f\u00f3rmula como esta con el criterio \u201c=\u201d&amp;\u201d\u201d. Cuando lo usa, tambi\u00e9n le dice a Excel que solo cuente las celdas sin valores. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67110\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-criteres-de-comptage-pour-les-cellules-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"n\u00famero-de-criterios-para-celdas-vac\u00edas\" width=\"478\" height=\"321\"><\/figure>\n<\/div>\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\/countif-cellules-vides-2.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-entre-dos-numeros\/\">Contar entre dos n\u00fameros (CONTAR.SI) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\">Cuente celdas menores que un valor particular (CONTAR.SI) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-celdas-no-iguales-a\/\">Contar celdas distintas a en Excel (CONTAR.SI)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-celdas-que-no-esten-en-blanco\/\">Contar celdas que no est\u00e1n vac\u00edas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cuenta-mayor-que-cero\/\">Cuente mayor que 0 (CONTAR.SI) 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>Si desea contar celdas en blanco en Excel, puede usar la funci\u00f3n CONTAR EN BLANCO que est\u00e1 especialmente dise\u00f1ada para contar celdas en blanco (sin ning\u00fan valor). En la funci\u00f3n CONTAR EN BLANCO, s\u00f3lo necesita hacer referencia al rango desde el cual desea contar las celdas en blanco. Utilice la funci\u00f3n CONTAR EN BLANCO En [&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-82","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 celdas en blanco en excel?<\/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\/numero-de-celdas-vacias\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo contar celdas en blanco en excel?\" \/>\n<meta property=\"og:description\" content=\"Si desea contar celdas en blanco en Excel, puede usar la funci\u00f3n CONTAR EN BLANCO que est\u00e1 especialmente dise\u00f1ada para contar celdas en blanco (sin ning\u00fan valor). En la funci\u00f3n CONTAR EN BLANCO, s\u00f3lo necesita hacer referencia al rango desde el cual desea contar las celdas en blanco. Utilice la funci\u00f3n CONTAR EN BLANCO En [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.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\/numero-de-celdas-vacias\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/\",\"name\":\"\u00bfc\u00f3mo contar celdas en blanco en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\",\"datePublished\":\"2023-11-17T07:33:43+00:00\",\"dateModified\":\"2023-12-25T10:24:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo contar celdas en blanco en excel?\"}]},{\"@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 celdas en blanco en excel?","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\/numero-de-celdas-vacias\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo contar celdas en blanco en excel?","og_description":"Si desea contar celdas en blanco en Excel, puede usar la funci\u00f3n CONTAR EN BLANCO que est\u00e1 especialmente dise\u00f1ada para contar celdas en blanco (sin ning\u00fan valor). En la funci\u00f3n CONTAR EN BLANCO, s\u00f3lo necesita hacer referencia al rango desde el cual desea contar las celdas en blanco. Utilice la funci\u00f3n CONTAR EN BLANCO En [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.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\/numero-de-celdas-vacias\/","url":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/","name":"\u00bfc\u00f3mo contar celdas en blanco en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png","datePublished":"2023-11-17T07:33:43+00:00","dateModified":"2023-12-25T10:24:37+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-plage-avec-des-cellules-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/numero-de-celdas-vacias\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo contar celdas en blanco en excel?"}]},{"@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\/82","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=82"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/82\/revisions"}],"predecessor-version":[{"id":940,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/82\/revisions\/940"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}