{"id":17568,"date":"2015-01-10T11:59:16","date_gmt":"2015-01-10T17:59:16","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=17568"},"modified":"2024-12-29T14:51:46","modified_gmt":"2024-12-29T20:51:46","slug":"formula-sumaproducto-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formula-sumaproducto-excel.html","title":{"rendered":"Como Aplicar la Formula SUMAPRODUCTO Excel"},"content":{"rendered":"<h1 style=\"text-align: center;\">\u00bfQu\u00e9 es la Formula SUMAPRODUCTO excel y como Usarlo?<\/h1>\n<p style=\"\">Hoy voy a mostrarte c\u00f3mo usar una nueva y emocionante Formula SUMAPRODUCTO Excel.<\/p>\n<p style=\"\">Al principio la Formula SUMAPRODUCTO Excel, puede parecer no tan \u00fatil, pero una vez que entiendas como funciona Excel con las listas de datos, entonces la Formula SUMAPRODUCTO Excel r\u00e1pidamente tomara mucha relevancia en tus labores.<\/p>\n<h2 style=\"text-align: center;\">Sintaxis de la Formula SUMAPRODUCTO Excel<\/h2>\n<p style=\"\">La Sintaxis de la Formula SUMAPRODUCTO Excel es muy simple.<\/p>\n<p style=\"\">Se necesita uno o m\u00e1s matrices de n\u00fameros para obtener la suma de los productos de n\u00fameros correspondientes.<\/p>\n<p style=\"\">La sintaxis de la Formula Excel es: =SUMAPRODUCTO (MATRIZ1; MATRIZ2; MATRIZ3;\u2026\u2026)<\/p>\n<p><span><img decoding=\"async\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58569\" width=\"335\" data-init-width=\"335\" height=\"67\" data-init-height=\"67\" title=\"Sintaxis de la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Sintaxis-de-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"335\" data-height=\"67\" style=\"aspect-ratio: auto 335 \/ 67;\"><\/span><\/p>\n<p style=\"\"><strong>Por ejemplo:<\/strong> Si tienes datos en una columna como (3,5,6) y en otra columna (4,8,12) y se aplica la Formula SUMAPRODUCTO, obtendr\u00e1s un resultado de 124, porque (3*4+5*8+6*12 es igual a 124).<\/p>\n<p><span><img decoding=\"async\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58570\" width=\"301\" data-init-width=\"301\" height=\"101\" data-init-height=\"101\" title=\"Ejemplo de la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Ejemplo-de-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"301\" data-height=\"101\" style=\"aspect-ratio: auto 301 \/ 101;\"><\/span><\/p>\n<p style=\"\">Estoy seguro que hasta este punto, todo parece ser irrelevante, una formula in\u00fatil, pero en los pr\u00f3ximos 2 minutos todo va a cambiar, sigue leyendo.<\/p>\n<h3 style=\"text-align: center;\">La Formula SUMAPRODUCTO Excel y las Matrices<\/h3>\n<p style=\"\">Vamos a suponer que tenemos una lista de datos de venta, con los encabezados: Nombre, Regi\u00f3n, Producto y Venta. Ahora t\u00fa quieres saber cu\u00e1nto a vendido en la Regi\u00f3n Norte el agente de ventas salom\u00f3n, en este caso tenemos dos opciones:<\/p>\n<ul>\n<li><span>Utilizar una Formula Excel Matricial<\/span><\/li>\n<li><span>Utilizar Tablas Din\u00e1micas<\/span><\/li>\n<\/ul>\n<p style=\"\">En realidad no son dos opciones, son tres opciones cuando incluimos a la Formula SUMAPRODUCTO Excel.<\/p>\n<p style=\"\">Si\u2026 te preguntaras \u00bfC\u00f3mo es posible? Pues d\u00e9jame decirte que con la Formula SUMAPRODUCTO Excel, puedes hacer esto y mucho m\u00e1s. <\/p>\n<p style=\"\">Veamos un ejemplo pr\u00e1ctico:<\/p>\n<h4 style=\"text-align: center;\">Utilizando la Formula SUMAPRODUCTO Excel como una Formula de Matriz<\/h4>\n<p><span><img decoding=\"async\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58577\" width=\"441\" data-init-width=\"441\" height=\"349\" data-init-height=\"349\" title=\"Tabla para aplicar la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Tabla-para-aplicar-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"441\" data-height=\"349\" style=\"aspect-ratio: auto 441 \/ 349;\"><\/span><\/p>\n<p style=\"\">En esta tabla puedes observar que tenemos Nombre, Regi\u00f3n, Producto y venta, y queremos saber cu\u00e1nto vendi\u00f3 Pablo Quince en la Regi\u00f3n Norte.<\/p>\n<p style=\"\">Este caso bien se podr\u00eda resolver con la Formula SUMAR.SI.CONJUNTO, pero como har\u00edas si lo quieres solucionar con la Formula SUMAPRODUCTO Excel?<\/p>\n<p style=\"\">A continuaci\u00f3n te muestro los pasos:<\/p>\n<ol>\n<li><span>1<\/span><span>Para eso nos ubicamos en la Celda L6 y escribimos la Formula, comenzando por el signo igual (=)<\/span><\/li>\n<li><span>2<\/span><span>Escribimos SUMAPRODUCTO y abre par\u00e9ntesis, doble guion y abre par\u00e9ntesis<\/span><\/li>\n<li><span>3<\/span><span>Seleccionamos la Matriz, en este caso de la G5:G15, escribimos igual (=), abrimos comilla y escribimos PABLO QUINCE, cerramos comilla.<\/span><\/li>\n<li><span>4<\/span><span>Escribimos el separador, en este en mi computador es el punto y coma, digitamos doble guion.<\/span><\/li>\n<li><span>5<\/span><span>Abrimos par\u00e9ntesis y seleccionamos la segunda matriz desde la H5:H15, escribimos igual y abrimos comilla. Escribimos NORTE y cerremos comilla m\u00e1s par\u00e9ntesis.<\/span><\/li>\n<li><span>6<\/span><span>Escribimos el separador y seleccionamos la tercera matriz desde la J5:J15. Cerramos par\u00e9ntesis y pulsamos enter.<\/span><\/li>\n<\/ol>\n<p style=\"\">Puedes notar que el resultado obtenido es de 6500, ahora lo puedes comprobar con una simple suma, los valores vendidos en el norte por el vendedor Pablo Quince es de 1500 + 5000 esto es igual a 6500.<\/p>\n<p style=\"\">Ahora si cambiamos la venta realizada de Pablo en el Sur a Norte, puedes notar que el valor cambia autom\u00e1ticamente a 10000.<\/p>\n<p style=\"\">Espero te sea de mucha ayuda este Tips de Formulas Excel, si es as\u00ed, te invito a que me dejes tu comentario al final de esta p\u00e1gina y no olvides compartirlo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">Facebook<\/a>:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfQu\u00e9 es la Formula SUMAPRODUCTO excel y como Usarlo? Hoy voy a mostrarte c\u00f3mo usar una nueva y emocionante Formula SUMAPRODUCTO Excel. Al principio la Formula SUMAPRODUCTO Excel, puede parecer no tan \u00fatil, pero una vez que entiendas como funciona Excel con las listas de datos, entonces la Formula SUMAPRODUCTO Excel r\u00e1pidamente tomara mucha relevancia [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":58577,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d93f609be\" style=\"\"><h1 data-css=\"tve-u-18d93f63934\" style=\"text-align: center;\" class=\"\">\u00bfQu\u00e9 es la Formula SUMAPRODUCTO excel y como Usarlo?<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d93f6df98\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d93f6df81\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hoy voy a mostrarte c\u00f3mo usar una nueva y emocionante Formula SUMAPRODUCTO Excel.<\/p><p style=\"\">Al principio la Formula SUMAPRODUCTO Excel, puede parecer no tan \u00fatil, pero una vez que entiendas como funciona Excel con las listas de datos, entonces la Formula SUMAPRODUCTO Excel r\u00e1pidamente tomara mucha relevancia en tus labores.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_responsive_video thrv_wrapper tcb-lazy-load tcb-lazy-load-youtube\" data-type=\"youtube\" data-rel=\"0\" data-modestbranding=\"1\" data-aspect-ratio=\"16:9\" data-aspect-ratio-default=\"0\" data-url=\"https:\/\/www.youtube.com\/watch?v=pQ4-L_DSl_k&amp;t=26s\" style=\"\" data-css=\"tve-u-18d93fd82a3\" id=\"video\">\n\t\n\n\t<div class=\"tve_responsive_video_container\" style=\"padding-bottom: 56.25%;\">\n\t\t<div class=\"video_overlay\"><\/div>\n\t<iframe title=\"Responsive Video\" class=\"tcb-responsive-video\" data-code=\"pQ4-L_DSl_k\" data-hash=\"undefined\" data-provider=\"youtube\" frameborder=\"0\" allowfullscreen=\"\" loading=\"lazy\" data-src=\"https:\/\/www.youtube.com\/embed\/pQ4-L_DSl_k?rel=0&amp;modestbranding=1&amp;controls=1&amp;showinfo=1&amp;fs=1&amp;wmode=transparent&amp;enablejsapi=1\"><\/iframe><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d93f609be\" style=\"\"><h2 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d93ff7d20\">Sintaxis de la Formula SUMAPRODUCTO Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">La Sintaxis de la Formula SUMAPRODUCTO Excel es muy simple.<\/p><p style=\"\">Se necesita uno o m\u00e1s matrices de n\u00fameros para obtener la suma de los productos de n\u00fameros correspondientes.<\/p><p style=\"\">La sintaxis de la Formula Excel es: =SUMAPRODUCTO (MATRIZ1; MATRIZ2; MATRIZ3;\u2026\u2026)<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d94031f9e\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-58569\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58569\" width=\"335\" data-init-width=\"335\" height=\"67\" data-init-height=\"67\" title=\"Sintaxis de la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Sintaxis-de-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"335\" data-height=\"67\" style=\"aspect-ratio: auto 335 \/ 67;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\"><strong>Por ejemplo:<\/strong> Si tienes datos en una columna como (3,5,6) y en otra columna (4,8,12) y se aplica la Formula SUMAPRODUCTO, obtendr\u00e1s un resultado de 124, porque (3*4+5*8+6*12 es igual a 124).<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d94081ee0\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-58570\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58570\" width=\"301\" data-init-width=\"301\" height=\"101\" data-init-height=\"101\" title=\"Ejemplo de la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Ejemplo-de-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"301\" data-height=\"101\" style=\"aspect-ratio: auto 301 \/ 101;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Estoy seguro que hasta este punto, todo parece ser irrelevante, una formula in\u00fatil, pero en los pr\u00f3ximos 2 minutos todo va a cambiar, sigue leyendo.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d940bd2f7\" style=\"\"><h3 data-css=\"tve-u-18d940bb97e\" style=\"text-align: center;\" class=\"\">La Formula SUMAPRODUCTO Excel y las Matrices<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Vamos a suponer que tenemos una lista de datos de venta, con los encabezados: Nombre, Regi\u00f3n, Producto y Venta. Ahora t\u00fa quieres saber cu\u00e1nto a vendido en la Regi\u00f3n Norte el agente de ventas salom\u00f3n, en este caso tenemos dos opciones:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-194142d8647\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-194142d7710\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18d940e8e07\"><div style=\"text-align: justify;\">Utilizar una Formula Excel Matricial<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-194142d7710\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-18d940e8e07\"><div style=\"text-align: justify;\">Utilizar Tablas Din\u00e1micas<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">En realidad no son dos opciones, son tres opciones cuando incluimos a la Formula SUMAPRODUCTO Excel.<\/p><p style=\"\">Si\u2026 te preguntaras \u00bfC\u00f3mo es posible? Pues d\u00e9jame decirte que con la Formula SUMAPRODUCTO Excel, puedes hacer esto y mucho m\u00e1s. <\/p><p style=\"\">Veamos un ejemplo pr\u00e1ctico:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d940bd2f7\" style=\"\"><h4 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d94126f32\">Utilizando la Formula SUMAPRODUCTO Excel como una Formula de Matriz<\/h4><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-18d94148d4c\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-58577\" alt=\"Formula SUMAPRODUCTO \" data-id=\"58577\" width=\"441\" data-init-width=\"441\" height=\"349\" data-init-height=\"349\" title=\"Tabla para aplicar la Formula Excel SUMAPRODUCTO\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Tabla-para-aplicar-la-Formula-Excel-SUMAPRODUCTO.png\" data-width=\"441\" data-height=\"349\" style=\"aspect-ratio: auto 441 \/ 349;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">En esta tabla puedes observar que tenemos Nombre, Regi\u00f3n, Producto y venta, y queremos saber cu\u00e1nto vendi\u00f3 Pablo Quince en la Regi\u00f3n Norte.<\/p><p style=\"\">Este caso bien se podr\u00eda resolver con la Formula SUMAR.SI.CONJUNTO, pero como har\u00edas si lo quieres solucionar con la Formula SUMAPRODUCTO Excel?<\/p><p style=\"\">A continuaci\u00f3n te muestro los pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-numbered_list\" data-start-number=\"1\" data-number-increment=\"1\"><ol class=\"tcb-numbered-list\"><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">1<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Para eso nos ubicamos en la Celda L6 y escribimos la Formula, comenzando por el signo igual (=)<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">2<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Escribimos SUMAPRODUCTO y abre par\u00e9ntesis, doble guion y abre par\u00e9ntesis<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">3<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Seleccionamos la Matriz, en este caso de la G5:G15, escribimos igual (=), abrimos comilla y escribimos PABLO QUINCE, cerramos comilla.<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">4<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Escribimos el separador, en este en mi computador es el punto y coma, digitamos doble guion.<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\"><span class=\"tcb-numbered-list-index\">5<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Abrimos par\u00e9ntesis y seleccionamos la segunda matriz desde la H5:H15, escribimos igual y abrimos comilla. Escribimos NORTE y cerremos comilla m\u00e1s par\u00e9ntesis.<\/div><\/span><\/li><li class=\"thrv-styled-list-item thrv-numbered-list-v2\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag \"><span class=\"tcb-numbered-list-index\">6<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-18d9417121c\"><div style=\"text-align: justify;\">Escribimos el separador y seleccionamos la tercera matriz desde la J5:J15. Cerramos par\u00e9ntesis y pulsamos enter.<\/div><\/span><\/li><\/ol><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18d94007f8d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-18d94007f77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Puedes notar que el resultado obtenido es de 6500, ahora lo puedes comprobar con una simple suma, los valores vendidos en el norte por el vendedor Pablo Quince es de 1500 + 5000 esto es igual a 6500.<\/p><p style=\"\">Ahora si cambiamos la venta realizada de Pablo en el Sur a Norte, puedes notar que el valor cambia autom\u00e1ticamente a 10000.<\/p><p style=\"\">Espero te sea de mucha ayuda este Tips de Formulas Excel, si es as\u00ed, te invito a que me dejes tu comentario al final de esta p\u00e1gina y no olvides compartirlo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">Facebook<\/a>:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-18d941d5bf6\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-de-facturacion-en-excel.html\" data-label=\"Compartir\" data-css=\"tve-u-18be2dd4a6b\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194142f255a\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194142f2558\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-194142f255b\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-194142f255c\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-194142f255d\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-194142f255e\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-194142f255f\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-18d93f609be\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18d93f63934\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; font-size: 42px !important; text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18d93f6df81\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d93f6df81\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18d93f6df81\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d93f6df98\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18d93fd82a3\"] { --tve-border-width: 3px; border: 3px solid rgba(10, 10, 10, 0.85); --tve-applied-border: 3px solid rgba(10,10,10,0.85); --tve-border-radius: 5px; border-radius: 5px; overflow: hidden; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }:not(#tve) [data-css=\"tve-u-18d93ff7d20\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; font-size: 38px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-18d94007f77\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-18d94007f77\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-18d94007f77\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-18d94007f8d\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-18d94031f9e\"] { width: 335px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18d94081ee0\"] { width: 301px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }:not(#tve) [data-css=\"tve-u-18d940bb97e\"] { color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; text-transform: none !important; }[data-css=\"tve-u-18d940bd2f7\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18d94126f32\"] { font-size: 30px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; text-transform: none !important; }[data-css=\"tve-u-18d94148d4c\"] { width: 441px; --tve-alignment: center; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18d941d5bf6\"] { float: none; margin-left: auto !important; margin-right: auto !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }[data-css=\"tve-u-194142d8647\"] { margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194142f2558\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194142f2558\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-194142f2558\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194142f255a\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-194142f255b\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-194142f255c\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-194142f255d\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-194142f255e\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-194142f255f\"] { --tcb-text-highlight-color: transparent !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[72],"tags":[66,99,132],"class_list":["post-17568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-excel","tag-excel","tag-formula-excel","tag-formula-excel-sumaproducto","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/17568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=17568"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/17568\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/58577"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=17568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=17568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=17568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}