{"id":263,"date":"2023-11-08T19:55:38","date_gmt":"2023-11-08T19:55:38","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/busquedasumif\/"},"modified":"2023-12-25T10:24:12","modified_gmt":"2023-12-25T10:24:12","slug":"busquedasumif","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/busquedasumif\/","title":{"rendered":"\u00bfc\u00f3mo combinar buscarv con sumar.si?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-747161645\"><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>S\u00ed, puedes combinar BUSCARV y SUMAR.SI. En SUMAR.SI hay un argumento de criterios donde puede usar BUSCARV para crear un valor din\u00e1mico. Esto le permitir\u00e1 cambiar los criterios cambiando el valor de b\u00fasqueda en BUSCARV. El uso de esta f\u00f3rmula combinada es \u00fanico. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77842\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"combinar-vlookup-con-sumif\" width=\"578\" height=\"526\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo combinar SUMAR.SI y BUSCARV para crear una f\u00f3rmula.<\/p>\n<h2 class=\"wp-block-heading\"> Combina SUMAR.SI y BUSCARV<\/h2>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese \u00ab=SUMAR.SI(\u00ab. Para el argumento de rango, consulte el rango de ID del producto que tiene en la Tabla 1.<\/li>\n<li> Despu\u00e9s de eso, en el segundo aumento, debe usar la funci\u00f3n BUSCARV para encontrar la ID del producto usando el nombre del producto en la celda de arriba.<\/li>\n<li> Luego, en el tercer argumento de SUMAR.SI, consulte la columna de cantidad para usar como rango_suma.<\/li>\n<li> Al final, ingrese el 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-77843\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumif-et-vlookup-combines.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-y-vlookup-combinados\" width=\"567\" height=\"349\"><\/figure>\n<\/div>\n<p class=\"formula\"> =SUMAR.SI(A2:A13,BUSCARV(B15,D1:E7,2,0),B2:B13) <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77845\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-avec-formule-vlookup.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula sumif-con-vlookup\" width=\"619\" height=\"83\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> \u00bfC\u00f3mo funciona esta f\u00f3rmula?<\/h2>\n<p> Dividamos esta f\u00f3rmula en tres partes: en la primera parte, especific\u00f3 el rango donde se encuentra el ID del producto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77846\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/formule-4-sumif-premiere-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula-sumif-primera-parte\" width=\"536\" height=\"389\"><\/figure>\n<\/div>\n<p> En la segunda parte, tienes la BUSCARV que toma el nombre del producto de la celda B15 y lo busca en la tabla2. Para auriculares tenemos el ID de producto OT-356. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77847\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-vlookup-en-deuxieme-partie.png\" sizes=\"auto, \" srcset=\"\" alt=\"vlookup-en-la-segunda-parte\" width=\"557\" height=\"417\"><\/figure>\n<\/div>\n<p> En la tercera parte, tenemos la columna de cantidad como sum_range. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77848\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-troisieme-partie-contient-la-plage-de-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"la tercera parte contiene el rango de suma\" width=\"566\" height=\"419\"><\/figure>\n<\/div>\n<p> En resumen, BUSCARV le ayuda a encontrar el ID del producto con el nombre del producto, luego SUMAR.SI toma ese ID del producto y lo busca en la columna ID del producto, luego suma los valores en la columna Cantidad.<\/p>\n<p> Como dije, cuando usas SUMAR.SI y BUSCARV, tu f\u00f3rmula se convierte en una f\u00f3rmula din\u00e1mica. Cuando cambia el nombre del producto en las celdas, cambia el resultado. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77849\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-sumif-vlookup-rend-la-formule-dynamique.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-vlookup-hacer-f\u00f3rmula-din\u00e1mica\" width=\"570\" height=\"350\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> SUMAR.SI y BUSCARV en varias hojas<\/h2>\n<p> Puede utilizar esta combinaci\u00f3n incluso cuando tenga las dos tablas en varias hojas de forma diferente. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-sumif-vlookup-dans-plusieurs-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-vlookup-en-varias-hojas\" width=\"572\" height=\"421\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, tiene la tabla de nombres del producto en una hoja diferente. <\/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\/sumif-vlookup-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\/suma-si-es-mayor-que\/\">Suma mayor que valores usando SUMAR.SI<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumos-no-iguales\/\">Suma de valores no iguales (SUMIFS) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-sumifs-o-logica\/\">SUMAR.SI\/SUMAR.SI con l\u00f3gica OR en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/\">SUMAR.SI con comodines en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-de-valores-entre-dos-fechas\/\">Rango de fechas SUMIFS (suma de valores entre dos matrices de fechas)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>S\u00ed, puedes combinar BUSCARV y SUMAR.SI. En SUMAR.SI hay un argumento de criterios donde puede usar BUSCARV para crear un valor din\u00e1mico. Esto le permitir\u00e1 cambiar los criterios cambiando el valor de b\u00fasqueda en BUSCARV. El uso de esta f\u00f3rmula combinada es \u00fanico. En este tutorial, aprenderemos c\u00f3mo combinar SUMAR.SI y BUSCARV para crear una [&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-263","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 combinar buscarv con sumar.si?<\/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\/busquedasumif\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo combinar buscarv con sumar.si?\" \/>\n<meta property=\"og:description\" content=\"S\u00ed, puedes combinar BUSCARV y SUMAR.SI. En SUMAR.SI hay un argumento de criterios donde puede usar BUSCARV para crear un valor din\u00e1mico. Esto le permitir\u00e1 cambiar los criterios cambiando el valor de b\u00fasqueda en BUSCARV. El uso de esta f\u00f3rmula combinada es \u00fanico. En este tutorial, aprenderemos c\u00f3mo combinar SUMAR.SI y BUSCARV para crear una [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/busquedasumif\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.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\/busquedasumif\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/\",\"name\":\"\u00bfc\u00f3mo combinar buscarv con sumar.si?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\",\"datePublished\":\"2023-11-08T19:55:38+00:00\",\"dateModified\":\"2023-12-25T10:24:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/busquedasumif\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/busquedasumif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo combinar buscarv con sumar.si?\"}]},{\"@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 combinar buscarv con sumar.si?","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\/busquedasumif\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo combinar buscarv con sumar.si?","og_description":"S\u00ed, puedes combinar BUSCARV y SUMAR.SI. En SUMAR.SI hay un argumento de criterios donde puede usar BUSCARV para crear un valor din\u00e1mico. Esto le permitir\u00e1 cambiar los criterios cambiando el valor de b\u00fasqueda en BUSCARV. El uso de esta f\u00f3rmula combinada es \u00fanico. En este tutorial, aprenderemos c\u00f3mo combinar SUMAR.SI y BUSCARV para crear una [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/busquedasumif\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.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\/busquedasumif\/","url":"https:\/\/exceladvisor.org\/es\/busquedasumif\/","name":"\u00bfc\u00f3mo combinar buscarv con sumar.si?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png","datePublished":"2023-11-08T19:55:38+00:00","dateModified":"2023-12-25T10:24:12+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/busquedasumif\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/busquedasumif\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/busquedasumif\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-combiner-vlookup-avec-sumif.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/busquedasumif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo combinar buscarv con sumar.si?"}]},{"@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\/263","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=263"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/263\/revisions"}],"predecessor-version":[{"id":910,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/263\/revisions\/910"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}