{"id":114,"date":"2023-11-16T08:05:21","date_gmt":"2023-11-16T08:05:21","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/"},"modified":"2023-12-25T10:23:06","modified_gmt":"2023-12-25T10:23:06","slug":"agregar-toda-la-columna","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/","title":{"rendered":"\u00bfc\u00f3mo agregar una columna o fila completa?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3304257006\"><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 la funci\u00f3n SUMA para sumar los valores de una columna o fila completa. En este tutorial veremos todos los m\u00e9todos que podemos utilizar para ello.<\/p>\n<h2 class=\"wp-block-heading\"> Agregar una columna completa<\/h2>\n<p> Como dije, puedes usar la funci\u00f3n SUMA para sumar los valores de una columna, y estos son los pasos a seguir:<\/p>\n<ol type=\"1\">\n<li> Primero, ingrese \u201c=SUMA\u201d en la celda donde desea calcular la suma.<\/li>\n<li> A continuaci\u00f3n, ingrese los par\u00e9ntesis iniciales.<\/li>\n<li> Despu\u00e9s de eso, consulte la columna para la que desea calcular la suma.<\/li>\n<li> Al final, ingrese los par\u00e9ntesis de cierre y presione Enter para obtener el resultado. <\/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-66032\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-una-columna-completa\" width=\"476\" height=\"380\"><\/figure>\n<\/div>\n<p> Como puede ver en el ejemplo anterior, utilizamos la funci\u00f3n de suma y nos referimos a <strong>la Columna A<\/strong> para obtener la suma de todos los valores de la columna. Y si desea resumir completamente una l\u00ednea, debe consultar la l\u00ednea como lo hicimos 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-66033\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formule-de-somme-a-la-colonne-de-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-suma-a-columna-suma\" width=\"481\" height=\"351\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Suma de m\u00faltiples columnas y filas.<\/h2>\n<p> Puede haber una situaci\u00f3n en la que necesite sumar los valores de varias columnas o filas; deber\u00e1 utilizar el m\u00e9todo que utilizamos en el siguiente ejemplo. Para varias columnas: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66034\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-additionner-plusieurs-lignes-et-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-muchas-filas-y-columnas\" width=\"488\" height=\"341\"><\/figure>\n<\/div>\n<p> Para varias filas, fila 1 y fila 2. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66035\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-pour-plusieurs-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma para m\u00faltiples l\u00edneas\" width=\"486\" height=\"400\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Suma de columnas o filas no adyacentes<\/h2>\n<p> Ahora, en el siguiente ejemplo, tiene la funci\u00f3n de suma para agregar varias columnas y filas no adyacentes. En el siguiente ejemplo tienes la f\u00f3rmula para sumar las columnas A y C <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66036\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Somme-de-5-lignes-de-colonnes-non-adjacentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-filas-columnas-no-adyacentes\" width=\"477\" height=\"343\"><\/figure>\n<\/div>\n<p> Y en este ejemplo, usaste la f\u00f3rmula para agregar filas no adyacentes. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-66037\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-a-6-lignes-non-adjacentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula de suma de filas no adyacentes\" width=\"522\" height=\"429\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, nos hemos referido a las l\u00edneas 1, 3 y 5. Entonces, si lo deseas.<\/p>\n<h2 class=\"wp-block-heading\"> Punto importante<\/h2>\n<p> Ser\u00eda mejor considerar que cuando se hace referencia a una columna o fila completa, siempre existe la posibilidad de obtener una suma incorrecta. En el siguiente ejemplo, tienes valores de la celda A1 a A16, pero te refieres a toda la columna.<\/p>\n<p> Si ingresas un valor en una de las celdas (incluso por error), la f\u00f3rmula tendr\u00e1 en cuenta ese valor. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84437\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-incorrecte.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma incorrecta\" width=\"405\" height=\"499\"><\/figure>\n<\/div>\n<p> Si tiene el valor en una celda debajo de A16 en alg\u00fan lugar, ese valor tambi\u00e9n se incluir\u00e1 en la suma. <\/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-toute-la-colonne-3.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> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-solo-celdas-visibles\/\">Suma solo celdas visibles en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-celdas-aleatorias\/\">Suma de celdas aleatorias en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/linea-total\/\">Agregar una fila total en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-automatica-1\/\">Utilice r\u00e1pidamente Autosuma 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>En Excel, puede utilizar la funci\u00f3n SUMA para sumar los valores de una columna o fila completa. En este tutorial veremos todos los m\u00e9todos que podemos utilizar para ello. Agregar una columna completa Como dije, puedes usar la funci\u00f3n SUMA para sumar los valores de una columna, y estos son los pasos a seguir: Primero, [&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-114","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 agregar una columna o fila completa?<\/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\/agregar-toda-la-columna\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo agregar una columna o fila completa?\" \/>\n<meta property=\"og:description\" content=\"En Excel, puede utilizar la funci\u00f3n SUMA para sumar los valores de una columna o fila completa. En este tutorial veremos todos los m\u00e9todos que podemos utilizar para ello. Agregar una columna completa Como dije, puedes usar la funci\u00f3n SUMA para sumar los valores de una columna, y estos son los pasos a seguir: Primero, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.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\/agregar-toda-la-columna\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/\",\"name\":\"\u00bfc\u00f3mo agregar una columna o fila completa?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png\",\"datePublished\":\"2023-11-16T08:05:21+00:00\",\"dateModified\":\"2023-12-25T10:23:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar una columna o fila completa?\"}]},{\"@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 agregar una columna o fila completa?","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\/agregar-toda-la-columna\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar una columna o fila completa?","og_description":"En Excel, puede utilizar la funci\u00f3n SUMA para sumar los valores de una columna o fila completa. En este tutorial veremos todos los m\u00e9todos que podemos utilizar para ello. Agregar una columna completa Como dije, puedes usar la funci\u00f3n SUMA para sumar los valores de una columna, y estos son los pasos a seguir: Primero, [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:06+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.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\/agregar-toda-la-columna\/","url":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/","name":"\u00bfc\u00f3mo agregar una columna o fila completa?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png","datePublished":"2023-11-16T08:05:21+00:00","dateModified":"2023-12-25T10:23:06+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-additionner-une-colonne-entiere.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar una columna o fila completa?"}]},{"@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\/114","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=114"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/114\/revisions"}],"predecessor-version":[{"id":817,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/114\/revisions\/817"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}