{"id":143,"date":"2023-11-15T10:25:02","date_gmt":"2023-11-15T10:25:02","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-4\/"},"modified":"2023-12-25T10:33:12","modified_gmt":"2023-12-25T10:33:12","slug":"suma-4","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-4\/","title":{"rendered":"Funci\u00f3n de excel: sumar.si"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1604124131\"><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><div class=\"wp-block-group is-layout-constrained\">\n<div class=\"wp-block-group__inner-container\">\n<h2 id=\"0-intro-sumif-function\" class=\"wp-block-heading\"> Introducci\u00f3n: funci\u00f3n SUMAR.SI<\/h2>\n<p> En Excel, cuando usas la funci\u00f3n SUMAR.SI, devuelve la suma de los valores que cumplen la condici\u00f3n que especificas. Debe especificar el rango de celdas para verificar la condici\u00f3n, luego un valor para verificar como condici\u00f3n y, al final, un rango desde el cual sumar los valores. Por tanto, hay tres argumentos a precisar. <\/p>\n<\/div>\n<\/div>\n<div class=\"wp-block-group is-layout-constrained\">\n<div class=\"wp-block-group__inner-container\">\n<h2 id=\"1-syntax\" class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> SUMAR.SI(rango, criterios, [rango_suma]) <\/p>\n<\/div>\n<\/div>\n<div class=\"wp-block-group is-layout-constrained\">\n<div class=\"wp-block-group__inner-container\">\n<h2 id=\"2-arguments\" class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>rango<\/strong> : un rango de celdas desde las cuales desea verificar los criterios.<\/li>\n<li> <strong>criterios<\/strong> : un criterio que puede ser un n\u00famero, texto, expresi\u00f3n, referencia de celda o funci\u00f3n.<\/li>\n<li> <strong>[sum_range]<\/strong> : un rango de celdas que contiene los valores que desea sumar. <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"wp-block-group is-layout-constrained\">\n<div class=\"wp-block-group__inner-container\">\n<h2 id=\"3-example\" class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> En el siguiente ejemplo, hemos especificado A1:A9 como rango de criterios y B1:B9 como rango de suma y luego hemos especificado los criterios en A12 que tiene el valor C. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37333\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-suma-funci\u00f3n-ejemplo-1\" width=\"416\" height=\"469\"><\/figure>\n<\/div>\n<p> Tambi\u00e9n puede insertar criterios directamente en la funci\u00f3n. En el siguiente ejemplo, utilizamos un comod\u00edn de asterisco para especificar un criterio que tiene el alfabeto \u00abS\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37334\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-suma-funcion-ejemplo-2\" width=\"457\" height=\"488\"><\/figure>\n<\/div>\n<p> Y, si ignora el rango de suma, le dar\u00e1 la suma del rango de criterios. Pero esto s\u00f3lo ser\u00e1 posible si el rango de criterios tiene valores num\u00e9ricos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37335\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-suma-funci\u00f3n-ejemplo-3\" width=\"449\" height=\"450\"><\/figure>\n<\/div>\n<\/div>\n<\/div>\n<h2 class=\"wp-block-heading\"> Archivo de ejemplo<\/h2>\n<p> <em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-2.xlsx\">Descargar un archivo de muestra<\/a><\/em> <\/p>\n<div class=\"wp-block-group main-page-bottom is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 id=\"4-related\" class=\"wp-block-heading\"> M\u00e1s tutoriales<\/h2>\n<ul>\n<li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/\">SUMAR.SI con comodines en Excel<\/a><\/li>\n<li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/es\/suma-de-valores-entre-dos-fechas\/\">Suma de valores entre dos fechas en Excel<\/a><\/li>\n<li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/es\/sumif-sumifs-o-logica\/\">SUMAR.SI\/SUMAR.SI con l\u00f3gica OR en Excel<\/a><\/li>\n<li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/es\/sumos-no-iguales\/\">Suma de valores no iguales (SUMIFS) en Excel<\/a><\/li>\n<li> <a class=\"\" href=\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que\/\">Sumar valores mayores usando SUMAR.SI en Excel<\/a><\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Funciones relacionadas<\/h2>\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumos-2\/\">Funci\u00f3n SUMA de Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumaproducto-2\/\">Funci\u00f3n de Excel SUMAPRODUCTO<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introducci\u00f3n: funci\u00f3n SUMAR.SI En Excel, cuando usas la funci\u00f3n SUMAR.SI, devuelve la suma de los valores que cumplen la condici\u00f3n que especificas. Debe especificar el rango de celdas para verificar la condici\u00f3n, luego un valor para verificar como condici\u00f3n y, al final, un rango desde el cual sumar los valores. Por tanto, hay tres argumentos [&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-143","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>Funci\u00f3n de excel: sumar.si<\/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-4\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n de excel: sumar.si\" \/>\n<meta property=\"og:description\" content=\"Introducci\u00f3n: funci\u00f3n SUMAR.SI En Excel, cuando usas la funci\u00f3n SUMAR.SI, devuelve la suma de los valores que cumplen la condici\u00f3n que especificas. Debe especificar el rango de celdas para verificar la condici\u00f3n, luego un valor para verificar como condici\u00f3n y, al final, un rango desde el cual sumar los valores. Por tanto, hay tres argumentos [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:33:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/suma-4\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-4\/\",\"name\":\"Funci\u00f3n de excel: sumar.si\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"datePublished\":\"2023-11-15T10:25:02+00:00\",\"dateModified\":\"2023-12-25T10:33:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-4\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Funci\u00f3n de excel: sumar.si\"}]},{\"@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":"Funci\u00f3n de excel: sumar.si","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-4\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n de excel: sumar.si","og_description":"Introducci\u00f3n: funci\u00f3n SUMAR.SI En Excel, cuando usas la funci\u00f3n SUMAR.SI, devuelve la suma de los valores que cumplen la condici\u00f3n que especificas. Debe especificar el rango de celdas para verificar la condici\u00f3n, luego un valor para verificar como condici\u00f3n y, al final, un rango desde el cual sumar los valores. Por tanto, hay tres argumentos [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-4\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:33:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.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\/suma-4\/","url":"https:\/\/exceladvisor.org\/es\/suma-4\/","name":"Funci\u00f3n de excel: sumar.si","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","datePublished":"2023-11-15T10:25:02+00:00","dateModified":"2023-12-25T10:33:12+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-4\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-4\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-4\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-sumif-exemple-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"Funci\u00f3n de excel: sumar.si"}]},{"@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\/143","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=143"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/143\/revisions"}],"predecessor-version":[{"id":1463,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/143\/revisions\/1463"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}