{"id":672,"date":"2023-09-28T22:49:35","date_gmt":"2023-09-28T22:49:35","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-1\/"},"modified":"2023-12-25T10:27:51","modified_gmt":"2023-12-25T10:27:51","slug":"suma-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-1\/","title":{"rendered":"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-461222155\"><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>En Excel, puede utilizar VBA para calcular la suma de valores de un rango de celdas o de varios rangos. Y, en este tutorial, aprenderemos las diferentes formas en que podemos usarlo.<\/p>\n<h2 class=\"wp-block-heading\"> Suma en VBA usando WorksheetFunction<\/h2>\n<p> En VBA, <a href=\"https:\/\/exceladvisor.org\/es\/funciones\/\">hay varias funciones<\/a> que puede utilizar, pero no existe una funci\u00f3n espec\u00edfica para este prop\u00f3sito. Esto no significa que no podamos hacer una suma. En VBA, existe una propiedad llamada <a href=\"https:\/\/exceladvisor.org\/es\/funcion-de-hoja-de-calculo\/\">WorksheetFunction<\/a> que puede ayudarle a llamar funciones en c\u00f3digo VBA. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61238\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-en-vba-usando-hoja de c\u00e1lculo\" width=\"463\" height=\"300\"><\/figure>\n<\/div>\n<p> Considere la suma de los valores en el rango A1:A10.<\/p>\n<ol>\n<li> Primero ingrese la propiedad de la funci\u00f3n de la hoja de trabajo, luego seleccione la funci\u00f3n SUMA de la lista. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-ingresar-funci\u00f3n-hoja-de-trabajo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-entrez-la-fonction-de-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-worksheet-function\" width=\"492\" height=\"298\"><\/li>\n<li> A continuaci\u00f3n, debe ingresar un par\u00e9ntesis inicial como lo hace cuando ingresa una funci\u00f3n en la hoja de c\u00e1lculo. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3 par\u00e9ntesis iniciales\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-parentheses-ouvrantes.png\" sizes=\"auto, \" srcset=\"\" alt=\"starting-parenthesis\" width=\"454\" height=\"285\"><\/li>\n<li> Despu\u00e9s de eso, necesitamos usar el <a href=\"https:\/\/exceladvisor.org\/es\/rango-1\/\">objeto de rango<\/a> para referirnos al rango para el cual queremos calcular la suma. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-usa-el-objeto-de-alcance\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-lobjet-range.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-the-range-object\" width=\"515\" height=\"249\"><\/li>\n<li> Al final, escriba un par\u00e9ntesis de cierre y asigne el valor de retorno de la funci\u00f3n a la celda B1. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-par\u00e9ntesis-de-cierre\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-parenthese-fermante.png\" sizes=\"auto, \" srcset=\"\" alt=\"closing-parenthesis\" width=\"653\" height=\"229\"><\/li>\n<\/ol>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum(Range(\"A1:A10\"))<\/code><\/pre>\n<p> Ahora cuando ejecutas este c\u00f3digo calcula la suma de los valores que tienes en el rango A1:A10 e <a href=\"https:\/\/exceladvisor.org\/es\/valor-de-celda\/\">ingresa el valor en la celda<\/a> B1. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61243\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-executer-le-code-pour-calculer.png\" sizes=\"auto, \" srcset=\"\" alt=\"ejecuta el c\u00f3digo para calcular\" width=\"722\" height=\"346\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Suma de valores de una columna o fila completa<\/h2>\n<p> En este caso, simplemente especifique una fila o columna en lugar del rango que usamos en el ejemplo anterior.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">' <strong>for<\/strong> the entire column A <strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum( <strong>Range<\/strong> (\"A:A\")) ' <strong>for<\/strong> entire row 1 <strong>Range<\/strong> (\"B1\") = Application.WorksheetFunction.Sum( <strong>Range<\/strong> (\"1:1\"))<\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Utilice VBA para agregar valores de selecci\u00f3n<\/h2>\n<p> Ahora suponga que desea sumar el valor de las celdas seleccionadas solo porque puede usar un c\u00f3digo como este.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_sum_selection() <strong>Dim<\/strong> sRange <strong>As<\/strong> Range <strong>Dim<\/strong> iSum <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler <strong>Set<\/strong> sRange = Selection iSum = WorksheetFunction.Sum(Range(sRange.Address)) MsgBox iSum errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<p> En el c\u00f3digo anterior, usamos la selecci\u00f3n, luego la especificamos en la variable \u00absRange\u00bb, luego usamos la direcci\u00f3n de esta variable de rango para obtener la suma.<\/p>\n<h2 class=\"wp-block-heading\"> Suma VBA de todas las celdas anteriores<\/h2>\n<p> El siguiente c\u00f3digo extrae todas las celdas y suma los valores e ingresa el resultado en la celda seleccionada.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_auto_sum() <strong>Dim<\/strong> iFirst <strong>As<\/strong> String <strong>Dim<\/strong> iLast <strong>As<\/strong> String <strong>Dim<\/strong> iRange <strong>As<\/strong> Range <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iFirst = Selection. <strong>End<\/strong> (xlUp). <strong>End<\/strong> (xlUp).Address iLast = Selection. <strong>End<\/strong> (xlUp).Address <strong>Set<\/strong> iRange = Range(iFirst &amp; \":\" &amp; iLast) ActiveCell = WorksheetFunction.Sum(iRange) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Agregue rango din\u00e1mico usando VBA<\/h2>\n<p> Y de manera similar, puede usar el rango din\u00e1mico mientras usa VBA para agregar valores.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_range_sum() <strong>Dim<\/strong> iFirst <strong>As<\/strong> String <strong>Dim<\/strong> iLast <strong>As<\/strong> String <strong>Dim<\/strong> iRange <strong>As<\/strong> Range <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iFirst = Selection.Offset(1, 1).Address iLast = Selection.Offset(5, 5).Address <strong>Set<\/strong> iRange = Range(iFirst &amp; \":\" &amp; iLast) ActiveCell = WorksheetFunction.Sum(iRange) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Agregar una columna o fila din\u00e1mica<\/h2>\n<p> De manera similar, si deseas utilizar una columna din\u00e1mica, puedes usar el siguiente c\u00f3digo que tomar\u00e1 la columna de la celda activa y sumar\u00e1 todos los valores que tienes all\u00ed.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_column() <strong>Dim<\/strong> iCol <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iCol = ActiveCell.Column MsgBox WorksheetFunction.Sum(Columns(iCol)) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<p> Y por una fila.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> vba_dynamic_row() <strong>Dim<\/strong> iRow <strong>As<\/strong> Long <strong>On<\/strong> <strong>Error<\/strong> <strong>GoTo<\/strong> errorHandler iRow = ActiveCell.Row MsgBox WorksheetFunction.Sum(Rows(iCol)) <strong>Exit<\/strong> <strong>Sub<\/strong> errorHandler: MsgBox \"make sure to select a valid range of cells\" <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<h2 class=\"wp-block-heading\"> Utilice SUMAR.SI con VBA<\/h2>\n<p> Al igual que la suma, puedes usar la funci\u00f3n SUMAR.SI para sumar valores con criterios 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-61244\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-avec-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-con-vba\" width=\"771\" height=\"332\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_sumif() Dim cRange <strong>As<\/strong> <strong>Range<\/strong> Dim sRange <strong>As<\/strong> <strong>Range<\/strong> <strong>Set<\/strong> cRange = <strong>Range<\/strong> (\"A2:A13\") <strong>Set<\/strong> sRange = <strong>Range<\/strong> (\"B2:B13\") <strong>Range<\/strong> (\"C2\") = _ WorksheetFunction.SumIf(cRange, \"Product B\", sRange) End Sub<\/code><\/pre>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/promedio-2\/\">Valores medios en Excel con VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fecha-de-hoy-hora-actual\/\">Obtenga la fecha y hora actual de hoy usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/partido-2\/\">Funci\u00f3n de coincidencia en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/modo-1\/\">MOD en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/numero-aleatorio\/\">n\u00fameros aleatorios VBA<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, puede utilizar VBA para calcular la suma de valores de un rango de celdas o de varios rangos. Y, en este tutorial, aprenderemos las diferentes formas en que podemos usarlo. Suma en VBA usando WorksheetFunction En VBA, hay varias funciones que puede utilizar, pero no existe una funci\u00f3n espec\u00edfica para este prop\u00f3sito. Esto [&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-672","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 usar sum en excel a trav\u00e9s de vba?<\/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-1\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?\" \/>\n<meta property=\"og:description\" content=\"En Excel, puede utilizar VBA para calcular la suma de valores de un rango de celdas o de varios rangos. Y, en este tutorial, aprenderemos las diferentes formas en que podemos usarlo. Suma en VBA usando WorksheetFunction En VBA, hay varias funciones que puede utilizar, pero no existe una funci\u00f3n espec\u00edfica para este prop\u00f3sito. Esto [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.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=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-1\/\",\"name\":\"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\",\"datePublished\":\"2023-09-28T22:49:35+00:00\",\"dateModified\":\"2023-12-25T10:27:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?\"}]},{\"@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 usar sum en excel a trav\u00e9s de vba?","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-1\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?","og_description":"En Excel, puede utilizar VBA para calcular la suma de valores de un rango de celdas o de varios rangos. Y, en este tutorial, aprenderemos las diferentes formas en que podemos usarlo. Suma en VBA usando WorksheetFunction En VBA, hay varias funciones que puede utilizar, pero no existe una funci\u00f3n espec\u00edfica para este prop\u00f3sito. Esto [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/suma-1\/","url":"https:\/\/exceladvisor.org\/es\/suma-1\/","name":"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","datePublished":"2023-09-28T22:49:35+00:00","dateModified":"2023-12-25T10:27:51+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-1\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-1\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-en-vba-en-utilisant-la-feuille-de-calcul.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo usar sum en excel a trav\u00e9s de vba?"}]},{"@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\/672","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=672"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/672\/revisions"}],"predecessor-version":[{"id":1238,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/672\/revisions\/1238"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}