{"id":330,"date":"2023-11-03T20:12:00","date_gmt":"2023-11-03T20:12:00","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/"},"modified":"2023-12-25T10:22:52","modified_gmt":"2023-12-25T10:22:52","slug":"suma-si-esta-vacio-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/","title":{"rendered":"\u00bfc\u00f3mo agregar celdas vac\u00edas en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2190290238\"><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>Para usar SUMAR.SI para sumar valores de criterios vac\u00edos, simplemente especifique un valor vac\u00edo en el argumento de criterios de la funci\u00f3n SUMAR.SI. Con esto, d\u00edgale a Excel que solo considere las celdas donde no hay ning\u00fan valor. En el siguiente ejemplo, tenemos tres celdas vac\u00edas en la columna de nombre para las cuales necesitamos sumar el monto de la donaci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77799\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-para-valores-en-blanco\" width=\"540\" height=\"519\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo usar la funci\u00f3n SUMAR.SI o SUMAR.SI para agregar valores vac\u00edos.<\/p>\n<h2 class=\"wp-block-heading\"> Escribe una f\u00f3rmula para usar SUMAR.SI para valores vac\u00edos<\/h2>\n<ol type=\"1\">\n<li> Primero, ingresa SUMAR.SI en una celda donde deseas calcular la suma.<\/li>\n<li> Ahora consulte la columna Nombre donde tiene celdas en blanco.<\/li>\n<li> Despu\u00e9s de eso, ingrese comillas dobles (inicio y cierre).<\/li>\n<li> A continuaci\u00f3n, consulte la columna Donaci\u00f3n desde donde debe sumar los valores.<\/li>\n<li> Al final, presione Enter para obtener el resultado. <\/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-77800\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-2-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-sumif-para-valores-en-blanco\" width=\"632\" height=\"459\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=SUMIF(A2:A13,\"\",B2:B13)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Un problema que podr\u00edas enfrentar<\/h2>\n<p> Puede haber una situaci\u00f3n en la que tenga un rango de celdas en el que tenga una o varias celdas con un espacio como valor en la celda que parece una celda vac\u00eda, pero no una celda vac\u00eda.<\/p>\n<p> En este caso, SUMAR.SI ignorar\u00e1 esta celda y no la incluir\u00e1 al calcular la suma. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77801\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-ignore-les-cellules-vides-avec-espace.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-ignorar-celdas-vacias-con-espacio\" width=\"441\" height=\"378\"><\/figure>\n<\/div>\n<p> Aqu\u00ed puede crear una f\u00f3rmula usando SUMIFS y SUM para crear un SUMIFS OR. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77802\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-et-somme-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma y suma\" width=\"482\" height=\"368\"><\/figure>\n<\/div>\n<p> En esta f\u00f3rmula, debe especificar dos criterios en el argumento criterio1 utilizando llaves.<\/p>\n<ul>\n<li> Espacio<\/li>\n<li> Blanco <\/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-77803\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-espace-a-deux-criteres-et-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"dos-criterios-espacio-y-blanco\" width=\"607\" height=\"102\"><\/figure>\n<\/div>\n<p> Cuando haces esto, SUMIF considera ambos criterios simult\u00e1neamente. Y para obtener el resultado, debe ingresarlo como una f\u00f3rmula matricial (use Ctrl + Alt + Enter).<\/p>\n<p class=\"formula\"> =SUMA(SUMARSI(B2:B13,A2:A13,{\u201c\u201d,\u201d \u201c}))<\/p>\n<p> Puedes encontrar mas <a href=\"https:\/\/exceladvisor.org\/es\/copiar-pegar\/\">aqui<\/a> . <\/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\/somme-si-vide.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/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\/suma-si-contiene\/\">Suma SI la celda contiene texto espec\u00edfico (SUMA SI texto parcial)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-ano-2\/\">Suma de valores seg\u00fan a\u00f1o (SUMIF A\u00f1o)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-por-fecha\/\">SUMAR.SI por fecha (suma de valores en base a una fecha)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-si-no-esta-vacia-2\/\">SUMIF no vac\u00edo (valores de suma para celdas no vac\u00edas)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/\">Suma de valores menores que un valor particular (SUMIF menor que)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para usar SUMAR.SI para sumar valores de criterios vac\u00edos, simplemente especifique un valor vac\u00edo en el argumento de criterios de la funci\u00f3n SUMAR.SI. Con esto, d\u00edgale a Excel que solo considere las celdas donde no hay ning\u00fan valor. En el siguiente ejemplo, tenemos tres celdas vac\u00edas en la columna de nombre para las cuales necesitamos [&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-330","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 agregar celdas vac\u00edas 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\/suma-si-esta-vacio-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo agregar celdas vac\u00edas en excel?\" \/>\n<meta property=\"og:description\" content=\"Para usar SUMAR.SI para sumar valores de criterios vac\u00edos, simplemente especifique un valor vac\u00edo en el argumento de criterios de la funci\u00f3n SUMAR.SI. Con esto, d\u00edgale a Excel que solo considere las celdas donde no hay ning\u00fan valor. En el siguiente ejemplo, tenemos tres celdas vac\u00edas en la columna de nombre para las cuales necesitamos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:22:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-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\/suma-si-esta-vacio-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/\",\"name\":\"\u00bfc\u00f3mo agregar celdas vac\u00edas en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"datePublished\":\"2023-11-03T20:12:00+00:00\",\"dateModified\":\"2023-12-25T10:22:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar celdas vac\u00edas 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 agregar celdas vac\u00edas 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\/suma-si-esta-vacio-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar celdas vac\u00edas en excel?","og_description":"Para usar SUMAR.SI para sumar valores de criterios vac\u00edos, simplemente especifique un valor vac\u00edo en el argumento de criterios de la funci\u00f3n SUMAR.SI. Con esto, d\u00edgale a Excel que solo considere las celdas donde no hay ning\u00fan valor. En el siguiente ejemplo, tenemos tres celdas vac\u00edas en la columna de nombre para las cuales necesitamos [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:22:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-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\/suma-si-esta-vacio-2\/","url":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/","name":"\u00bfc\u00f3mo agregar celdas vac\u00edas en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","datePublished":"2023-11-03T20:12:00+00:00","dateModified":"2023-12-25T10:22:52+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-si-esta-vacio-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar celdas vac\u00edas 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\/330","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=330"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/330\/revisions"}],"predecessor-version":[{"id":797,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/330\/revisions\/797"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}