{"id":14213,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/suma\/"},"modified":"2021-02-26T08:58:34","modified_gmt":"2021-02-26T08:58:34","slug":"sum","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/sum\/","title":{"rendered":"SUMA"},"content":{"rendered":"

La funci\u00f3n SUMA en Microsoft Excel y Google Sheets es una herramienta fundamental para la gesti\u00f3n de datos num\u00e9ricos. Esta funci\u00f3n facilita la suma de rangos de celdas, as\u00ed como la adici\u00f3n de n\u00fameros sueltos, referencias de celdas o rangos completos. A continuaci\u00f3n, exploraremos c\u00f3mo se implementa esta funci\u00f3n en ambos programas, proporcionando ejemplos pr\u00e1cticos y algunos casos de uso comunes.<\/p>\n

Descripci\u00f3n y Sintaxis de la Funci\u00f3n<\/h2>\n

La funci\u00f3n SUMA se utiliza para sumar dos o m\u00e1s n\u00fameros, celdas individuales o rangos de celdas. Su sintaxis es sencilla:<\/p>\n

=SUMA(n\u00famero1, [n\u00famero2], ...)<\/code><\/pre>\n
En la f\u00f3rmula, \u00abn\u00famero1\u00bb, \u00abn\u00famero2\u00bb, etc., pueden ser n\u00fameros directos, referencias de celdas o rangos de celdas. Veamos algunos ejemplos:<\/p>\n
    \n
  • =SUMA(1, 2)<\/code> – Esto realiza una simple adici\u00f3n de 1 + 2, resultando en 3.<\/li>\n
  • =SUMA(A1, A2)<\/code> – Suma los valores contenidos en las celdas A1 y A2.<\/li>\n
  • =SUMA(A1:A5)<\/code> – Calcula la suma total de los valores desde A1 hasta A5.<\/li>\n<\/ul>\n
    Casos Pr\u00e1cticos de Uso<\/h2>\n
    Creaci\u00f3n de un Reporte de Gastos<\/h2>\n
    Imagina que necesitas elaborar un reporte mensual de gastos en Excel o Google Sheets. Supongamos que las diferentes categor\u00edas de gastos se organizan en una columna y los montos correspondientes en la columna adyacente. As\u00ed es c\u00f3mo podr\u00edas emplear la funci\u00f3n SUMA para calcular el total de gastos:<\/p>\n
     A B 1 Categor\u00eda Costo 2 Alimentos $1,200 3 Transporte $300 4 Entretenimiento $400 5 Otros $150 6 Total =SUMA(B2:B5) <\/code><\/pre>\n
    En la celda B6, la f\u00f3rmula =SUMA(B2:B5)<\/code> suma todos los gastos para proporcionar un total general.<\/p>\n
    Sumar Celdas Condicionales<\/h2>\n
    Un uso avanzado de la funci\u00f3n SUMA incluye realizar sumas condicionales, esto se puede lograr combin\u00e1ndola con funciones como SI. Por ejemplo, podr\u00edas querer sumar solo aquellos precios que superen un umbral determinado. Veamos c\u00f3mo sumar todos los valores que excedan los $500:<\/p>\n
     A B 1 Producto Precio 2 Producto A $600 3 Producto B $450 4 Producto C $700 5 Total =SUMA(SI(B2:B4>500, B2:B4, 0)) <\/code><\/pre>\n
    En la celda B5, se utiliza una funci\u00f3n SI dentro de SUMA para incluir solo aquellos valores en B2:B4 que son superiores a $500.<\/p>\n
    Estos ejemplos demuestran c\u00f3mo la funci\u00f3n SUMA puede ser aplicada tanto en tareas cotidianas sencillas como en an\u00e1lisis financieros complejos donde es necesario evaluar condiciones espec\u00edficas.<\/p>\n\n\n\n
    Funci\u00f3n<\/th>\nDescripci\u00f3n<\/th>\n<\/tr>\n
    SUMA<\/td>\nPermite la sumatoria de valores num\u00e9ricos y rangos especificados como par\u00e1metros.<\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
    Suma sus argumentos<\/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-14213","post","type-post","status-publish","format-standard","hentry","category-matematicas-y-trigonometria"],"acf":[],"yoast_head":"\nFunci\u00f3n SUM (SUMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) 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\/sum\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n SUM (SUMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/sum\/\" \/>\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-02-26T08:58:34+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 SUM (SUMA) 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\/sum\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/sum\/\",\"name\":\"Funci\u00f3n SUM (SUMA) 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-02-26T08:58:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/sum\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/sum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/sum\/#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\":\"SUMA\"}]},{\"@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 SUM (SUMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) 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\/sum\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n SUM (SUMA) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/sum\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:58:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n SUM (SUMA) 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\/sum\/","url":"https:\/\/functiontranslator.com\/es\/sum\/","name":"Funci\u00f3n SUM (SUMA) 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-02-26T08:58:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n SUM (SUMA) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/sum\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/sum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/sum\/#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":"SUMA"}]},{"@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\/14213","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=14213"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14213\/revisions"}],"predecessor-version":[{"id":30322,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/14213\/revisions\/30322"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=14213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=14213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=14213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}