{"id":14215,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/sumifs-function\/"},"modified":"2021-03-01T16:38:56","modified_gmt":"2021-03-01T16:38:56","slug":"sumifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/sumifs\/","title":{"rendered":"SUMIFS"},"content":{"rendered":"

Introducci\u00f3n a la funci\u00f3n de sumas condicionales<\/h2>\n

En Microsoft Excel y Google Sheets, la funci\u00f3n SUMIFS permite sumar valores de un rango dependiendo de m\u00faltiples criterios especificados. Esta herramienta es extremadamente \u00fatil en el an\u00e1lisis de datos para obtener sumas r\u00e1pidas basadas en condiciones espec\u00edficas.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis b\u00e1sica de la funci\u00f3n en Excel es:<\/p>\n

SUMIFS(rango_suma, rango_criterio1, criterio1, [rango_criterio2, criterio2, ...])<\/code><\/pre>\n
Donde:<\/p>\n
    \n
  • rango_suma<\/strong>: El rango de celdas que se sumar\u00e1n si cumplen con los criterios.<\/li>\n
  • rango_criterio1<\/strong>: El rango de celdas que se evaluar\u00e1n con el primer criterio.<\/li>\n
  • criterio1<\/strong>: El criterio que deben cumplir las celdas del rango_criterio1 para ser incluidas en la suma.<\/li>\n
  • Los argumentos adicionales [rango_criterio2], [criterio2], … son opcionales y permiten a\u00f1adir m\u00e1s criterios.<\/li>\n<\/ul>\n
    Un ejemplo pr\u00e1ctico<\/strong> ser\u00eda:<\/p>\n
     Supongamos que tenemos una tabla con las siguientes informaciones de ventas: 
     
    Producto<\/th>Regi\u00f3n<\/th>Ventas<\/th><\/tr> 
    A<\/td>Norte<\/td>100<\/td><\/tr> 
    A<\/td>Sur<\/td>200<\/td><\/tr> 
    B<\/td>Norte<\/td>150<\/td><\/tr> 
    B<\/td>Sur<\/td>100<\/td><\/tr> <\/table> Si queremos calcular el total de ventas para el producto A en la regi\u00f3n Norte, usar\u00edamos: =SUMIFS(C2:C5, A2:A5, \"A\", B2:B5, \"Norte\")<\/code> Esta f\u00f3rmula devolver\u00e1 100<\/strong>. <\/pre>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    Caso 1: Presupuesto anual filtrado<\/strong><\/p>\n
    Supongamos que tienes un presupuesto anual dividido por departamentos y meses. Para calcular el gasto total en el departamento de Marketing durante los primeros seis meses del a\u00f1o, la configuraci\u00f3n ser\u00eda:<\/p>\n
     Filtrar el total de gastos de Marketing de enero a junio: =SUMIFS(C2:C13, B2:B13, \"Marketing\", A2:A13, \">=1\/1\/2023\", A2:A13, \"<=6\/30\/2023\")<\/code> <\/pre>\n
    En este caso, C2:C13 ser\u00eda el rango de los gastos, B2:B13 el rango de los departamentos y A2:A13 el rango de las fechas.<\/p>\n
    Caso 2: Ventas m\u00ednimas por empleado<\/strong><\/p>\n
    Si queremos calcular la suma de ventas realizadas por los empleados que han vendido por lo menos $500, usar\u00edamos:<\/p>\n
     Calcular ventas para empleados con ventas >= $500: =SUMIFS(C2:C10, C2:C10, \">=500\")<\/code> <\/pre>\n
    Aqu\u00ed, C2:C10 representa el rango de las ventas de cada empleado.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Suma las celdas de un rango que cumplen varios criterios<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[535],"tags":[],"class_list":["post-14215","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/sumifs\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/sumifs\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-01T16:38:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/sumifs\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/sumifs\/\",\"name\":\"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-03-01T16:38:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/sumifs\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/sumifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/sumifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1ticas y trigonometr\u00eda\",\"item\":\"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SUMIFS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","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:\/\/functiontranslator.com\/es\/sumifs\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/sumifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-03-01T16:38:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/sumifs\/","url":"https:\/\/functiontranslator.com\/es\/sumifs\/","name":"Funci\u00f3n SUMIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-03-01T16:38:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n SUMIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/sumifs\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/sumifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/sumifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1ticas y trigonometr\u00eda","item":"https:\/\/functiontranslator.com\/es\/matematicas-y-trigonometria\/"},{"@type":"ListItem","position":3,"name":"SUMIFS"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=14215"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14215\/revisions"}],"predecessor-version":[{"id":32539,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14215\/revisions\/32539"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}