{"id":210,"date":"2023-11-11T15:13:22","date_gmt":"2023-11-11T15:13:22","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/"},"modified":"2023-12-25T10:27:36","modified_gmt":"2023-12-25T10:27:36","slug":"suma-si-es-menor-que","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/","title":{"rendered":"\u00bfc\u00f3mo sumar valores menores que a?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2377024699\"><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 sumar valores menores que un valor en particular, debe usar la funci\u00f3n SUMAR.SI en Excel. Debe especificar el rango de celdas para verificar los criterios, un valor para usar como criterio y luego el rango desde el cual desea sumar los valores. Pero tambi\u00e9n puedes usar el mismo rango para sumar los valores y verificar los criterios. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79486\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-valores-menores-que\" width=\"673\" height=\"292\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir una f\u00f3rmula para sumar valores menores que un valor particular.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula: SUMAR SI Menos que<\/h2>\n<p> Puede utilizar los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese la funci\u00f3n SUMAR.SI.<\/li>\n<li> Despu\u00e9s de eso, en el primer argumento, indique el rango en el que necesita verificar los criterios. En nuestro ejemplo, debe consultar el rango de tama\u00f1o del lote.<\/li>\n<li> Ahora necesita especificar los criterios aqu\u00ed. Entonces usaremos un 40 con un operador menor que para sumar todos los valores menores que.<\/li>\n<li> A continuaci\u00f3n, nos referiremos al rango donde tenemos valores para sumar. En nuestro ejemplo, debe consultar el rango de cantidades.<\/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-79487\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-somme-si-moins-de.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-menor que\" width=\"616\" height=\"293\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A10,\"&lt;40\",C2:C10)<\/code><\/pre>\n<p> Como puedes ver tenemos 685 en el resultado. Esto significa que la suma de todos los valores en la columna de cantidad donde el valor en la columna de tama\u00f1o de lote es menor que 40 es 685. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79488\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultat-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultado-sumif\" width=\"621\" height=\"242\"><\/figure>\n<\/div>\n<p> Cuando usa un signo menor que con el valor, no incluye ese valor mientras la suma sea menor que los valores. Esto significa que con &lt;40, el valor 40 no se incluye. Para esto tambi\u00e9n debes utilizar el signo igual, de la siguiente manera. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79489\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-resultat-sumif-avec-signe-inferieur.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultado-sumif-con-signo-inferior\" width=\"631\" height=\"333\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A10,\"&lt;=40\",C2:C10)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Usando valor menor que una celda<\/h2>\n<p> Digamos que en lugar de especificar el valor en la funci\u00f3n, desea usarlo para una celda. En este caso, debes escribir tu f\u00f3rmula como en el siguiente ejemplo: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79490\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-en-utilisant-moins-que-la-valeur-dune-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"usar menos que un valor de celda\" width=\"696\" height=\"302\"><\/figure>\n<\/div>\n<p> Aqu\u00ed debe usar el signo menor que usando comillas dobles y luego usar un signo comercial y combinarlo con la celda en la que tiene el valor menor que.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A10,\"&lt;\"&amp;E5,C2:C10)<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> SUMIF Menos que cuando tienes el mismo rango para verificar criterios<\/h2>\n<p> Ahora pensemos en otra situaci\u00f3n en la que tiene el mismo rango para sumar los valores y verificar menos de los criterios. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79491\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-somme-si-inferieur-a-avec-la-meme-plage-et-les-memes-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-menor-que-con-el-mismo-rango-y-criterios\" width=\"628\" height=\"349\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, hicimos referencia a la columna de cantidad en el rango de criterios y en los criterios especificados &lt;150, pero no especificamos ning\u00fan rango en el argumento rango_suma. En SUMAR.SI, rango_suma es opcional. Y cuando lo ignoras, la funci\u00f3n utilizar\u00e1 el rango de criterios para sumar los valores.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(C2:C10,\"&lt;150\")<\/code><\/pre>\n<p> En la f\u00f3rmula anterior, SUMAR.SI suma valores inferiores a 150 de la columna de cantidad. <\/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\/sumif-inferieur-a-fichier.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\/suma-si-es-mayor-que\/\">Suma mayor que valores usando SUMAR.SI<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumos-no-iguales\/\">Suma de valores no iguales (SUMIFS) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-sumifs-o-logica\/\">SUMAR.SI\/SUMAR.SI con l\u00f3gica OR en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/\">SUMAR.SI con comodines en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-de-valores-entre-dos-fechas\/\">Rango de fechas SUMIFS (suma de valores entre dos matrices de fechas)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para sumar valores menores que un valor en particular, debe usar la funci\u00f3n SUMAR.SI en Excel. Debe especificar el rango de celdas para verificar los criterios, un valor para usar como criterio y luego el rango desde el cual desea sumar los valores. Pero tambi\u00e9n puedes usar el mismo rango para sumar los valores y [&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-210","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 sumar valores menores que a?<\/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-es-menor-que\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo sumar valores menores que a?\" \/>\n<meta property=\"og:description\" content=\"Para sumar valores menores que un valor en particular, debe usar la funci\u00f3n SUMAR.SI en Excel. Debe especificar el rango de celdas para verificar los criterios, un valor para usar como criterio y luego el rango desde el cual desea sumar los valores. Pero tambi\u00e9n puedes usar el mismo rango para sumar los valores y [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.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=\"3 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-es-menor-que\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/\",\"name\":\"\u00bfc\u00f3mo sumar valores menores que a?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png\",\"datePublished\":\"2023-11-11T15:13:22+00:00\",\"dateModified\":\"2023-12-25T10:27:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo sumar valores menores que a?\"}]},{\"@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 sumar valores menores que a?","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-es-menor-que\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo sumar valores menores que a?","og_description":"Para sumar valores menores que un valor en particular, debe usar la funci\u00f3n SUMAR.SI en Excel. Debe especificar el rango de celdas para verificar los criterios, un valor para usar como criterio y luego el rango desde el cual desea sumar los valores. Pero tambi\u00e9n puedes usar el mismo rango para sumar los valores y [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/","url":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/","name":"\u00bfc\u00f3mo sumar valores menores que a?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png","datePublished":"2023-11-11T15:13:22+00:00","dateModified":"2023-12-25T10:27:36+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-inferieures-a.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-menor-que\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo sumar valores menores que a?"}]},{"@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\/210","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=210"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/210\/revisions"}],"predecessor-version":[{"id":1211,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/210\/revisions\/1211"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}