{"id":209,"date":"2023-11-11T15:33:29","date_gmt":"2023-11-11T15:33:29","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/"},"modified":"2023-12-25T10:23:54","modified_gmt":"2023-12-25T10:23:54","slug":"suma-acumulada-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/","title":{"rendered":"\u00bfc\u00f3mo calcular la suma acumulada de valores?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-755779336\"><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 calcular la suma acumulada en Excel, debe utilizar la f\u00f3rmula SUMA. Debe consultar los valores anteriores y el valor actual en la f\u00f3rmula y luego arrastrar esta f\u00f3rmula a todas las celdas hasta las cuales desea calcular el total acumulado (suma acumulada).<\/p>\n<p> En este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula y algunas otras f\u00f3rmulas para hacer frente a diferentes situaciones.<\/p>\n<h2 class=\"wp-block-heading\"> F\u00f3rmula para calcular una suma acumulada<\/h2>\n<p> Puede utilizar los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Primero ingrese la funci\u00f3n de suma en la celda C2.<\/li>\n<li> Luego consulte el rango B2:B3. Este rango incluye la cantidad para el d\u00eda 1 y el d\u00eda 2.<\/li>\n<li> Ahora use el signo de d\u00f3lar antes del n\u00famero de l\u00ednea de la referencia de celda.<\/li>\n<li> Luego ingrese a la funci\u00f3n para obtener el total acumulado de dos d\u00edas (1 y 2).<\/li>\n<li> Al final, arrastre la f\u00f3rmula a la \u00faltima celda de la columna para obtener el total acumulado de todos los d\u00edas. <\/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-79324\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-para-suma-acumulada\" width=\"520\" height=\"519\"><\/figure>\n<\/div>\n<p> Puedes ver que cuando usas el signo de d\u00f3lar, congela la primera celda y en cada celda calcula la suma acumulada de todos los d\u00edas anteriores. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79325\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-signe-pour-geler-la-valeur-precedente.png\" sizes=\"auto, \" srcset=\"\" alt=\"$-signo para congelar-valor-anterior\" width=\"470\" height=\"406\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Suma acumulada por fecha<\/h2>\n<p> Si tiene datos con fechas como los que tenemos en la columna A. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79326\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-cumulee-par-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-acumulada-por-fecha\" width=\"464\" height=\"501\"><\/figure>\n<\/div>\n<p> Para obtener el total acumulado por fecha, primero debe ordenar los datos de antiguos a nuevos. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79327\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-trier-la-date-de-lancien-au-nouveau.png\" sizes=\"auto, \" srcset=\"\" alt=\"ordenar-fecha-de-viejo-a-nuevo\" width=\"449\" height=\"487\"><\/figure>\n<\/div>\n<p> Despu\u00e9s de eso, escribe la f\u00f3rmula, de la misma manera que lo hicimos en el ejemplo anterior. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79328\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-somme-pour-obtenir-le-total-cumule-par-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-para-obtener-la-fecha-sabio-ejecuci\u00f3n-total\" width=\"462\" height=\"549\"><\/figure>\n<\/div>\n<p> Y al final, arrastra esta f\u00f3rmula a la \u00faltima celda con la fecha. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79329\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-faites-glisser-la-formule-jusqua-la-cellule-de-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"arrastra la f\u00f3rmula hasta el final de la celda\" width=\"466\" height=\"522\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Monto acumulado por mes<\/h2>\n<p> En el siguiente ejemplo, tenemos fechas en la columna A y queremos calcular el total acumulado en funci\u00f3n de meses en lugar de fechas. Para ello, lo primero que debe hacer es agregar una columna separada con los nombres de los meses. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79330\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-somme-cumulee-par-mois.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-acumulada-por-mes\" width=\"584\" height=\"441\"><\/figure>\n<\/div>\n<p> Ahora, en la siguiente columna, ingrese la siguiente f\u00f3rmula haciendo referencia a la columna de fecha y cantidad en la tabla original. <\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(TEXT($A$2:$A$11,\"MMM\")=D2),$B$2:$B$11)<\/code><\/pre>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79331\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumproduct-faisant-reference-a-la-date-et-a-la-quantite.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumaproducto-fecha-referencia-y-cantidad\" width=\"656\" height=\"479\"><\/figure>\n<\/div>\n<p> Esta f\u00f3rmula le dar\u00e1 un total mensual para cada mes. Y para los meses para los que no tienes fecha tendr\u00e1 0. Lo siguiente de aqu\u00ed es agregar una columna para el total acumulado (suma acumulada).<\/p>\n<p> De la misma manera, ingrese la funci\u00f3n de suma, consulte las celdas E2 y E3 y congele la fila de la celda E2 usando el signo de d\u00f3lar antes del n\u00famero de fila. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79332\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-entrez-la-formule-de-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"ingrese la f\u00f3rmula de suma\" width=\"643\" height=\"429\"><\/figure>\n<\/div>\n<p> Despu\u00e9s de eso, arrastre la f\u00f3rmula al \u00faltimo mes de la celda. <\/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\/11\/somme-cumulee.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> Calcular la ra\u00edz c\u00fabica en Excel.<\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/diferencia-porcentual\/\">Calcular la varianza porcentual (diferencia) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/raiz-cuadrada\/\">Calcular ra\u00edz cuadrada en Excel + Insertar s\u00edmbolo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/no-es-igual\/\">No es igual al operador en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para calcular la suma acumulada en Excel, debe utilizar la f\u00f3rmula SUMA. Debe consultar los valores anteriores y el valor actual en la f\u00f3rmula y luego arrastrar esta f\u00f3rmula a todas las celdas hasta las cuales desea calcular el total acumulado (suma acumulada). En este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula y algunas otras f\u00f3rmulas [&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-209","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 calcular la suma acumulada de valores?<\/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-acumulada-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo calcular la suma acumulada de valores?\" \/>\n<meta property=\"og:description\" content=\"Para calcular la suma acumulada en Excel, debe utilizar la f\u00f3rmula SUMA. Debe consultar los valores anteriores y el valor actual en la f\u00f3rmula y luego arrastrar esta f\u00f3rmula a todas las celdas hasta las cuales desea calcular el total acumulado (suma acumulada). En este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula y algunas otras f\u00f3rmulas [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.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-acumulada-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/\",\"name\":\"\u00bfc\u00f3mo calcular la suma acumulada de valores?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\",\"datePublished\":\"2023-11-11T15:33:29+00:00\",\"dateModified\":\"2023-12-25T10:23:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo calcular la suma acumulada de valores?\"}]},{\"@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 calcular la suma acumulada de valores?","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-acumulada-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo calcular la suma acumulada de valores?","og_description":"Para calcular la suma acumulada en Excel, debe utilizar la f\u00f3rmula SUMA. Debe consultar los valores anteriores y el valor actual en la f\u00f3rmula y luego arrastrar esta f\u00f3rmula a todas las celdas hasta las cuales desea calcular el total acumulado (suma acumulada). En este tutorial, aprenderemos c\u00f3mo escribir esta f\u00f3rmula y algunas otras f\u00f3rmulas [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:54+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.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-acumulada-2\/","url":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/","name":"\u00bfc\u00f3mo calcular la suma acumulada de valores?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png","datePublished":"2023-11-11T15:33:29+00:00","dateModified":"2023-12-25T10:23:54+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-formule-de-somme-cumulee.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-acumulada-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo calcular la suma acumulada de valores?"}]},{"@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\/209","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=209"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/209\/revisions"}],"predecessor-version":[{"id":882,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/209\/revisions\/882"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}