{"id":26992,"date":"2025-11-18T12:30:00","date_gmt":"2025-11-18T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=26992"},"modified":"2025-11-18T09:44:35","modified_gmt":"2025-11-18T14:44:35","slug":"sumar-con-condiciones-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/","title":{"rendered":"sumar con condiciones en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-sumar-con-condiciones-en-excel\">Sumar con Condiciones en Excel<\/h1>\n\n\n\n<p>Cuando empiezas a trabajar con datos, la funci\u00f3n <code>=SUMA<\/code> es tu mejor amiga. Pero, \u00bfqu\u00e9 pasa cuando tu jefe te pide \u00absolo las ventas de Carlos\u00bb o \u00ablos totales de la regi\u00f3n norte\u00bb? Ah\u00ed es donde la suma simple se queda corta y necesitas aprender a <strong>sumar con condiciones en Excel<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"\u00bfC\u00f3mo Sumar con M\u00faltiples Condiciones en Excel? (SUMAR.SI.CONJUNTO)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ngUVb2fAvpI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">No te preocupes, no es complicado. Excel nos da dos funciones incre\u00edblemente potentes para esto: <code>SUMAR.SI<\/code>, para cuando tienes una sola pregunta (un criterio), y <code>SUMAR.SI.CONJUNTO<\/code>, para cuando tienes m\u00faltiples preguntas (varios criterios).<\/p>\n\n\n\n<p>En este tutorial, te guiaremos paso a paso para que domines ambas funciones y puedas filtrar tus totales como un verdadero profesional.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-629087f1\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-aa757f\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-508be3 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-condiciones-Material-de-Apoyo.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-59644ca8\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-que-es-el-rango-suma-el-primer-paso-clave\">\u00bfQu\u00e9 es el Rango Suma? El Primer Paso Clave<\/h2>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-e30ef7b7 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Antes de escribir cualquier f\u00f3rmula, necesitas entender un concepto fundamental: el <strong>Rango Suma<\/strong>.<\/p>\n\n\n\n<p>Pi\u00e9nsalo de esta manera: es simplemente <strong>la columna que quieres sumar<\/strong>. Si tu jefe te pide el total de ventas, tu \u00abRango Suma\u00bb es la columna \u00abMonto\u00bb o \u00abVentas\u00bb. Si te pide el total de unidades, ser\u00e1 la columna \u00abCantidad\u00bb. Identificar esto primero hace que todo lo dem\u00e1s sea mucho m\u00e1s f\u00e1cil.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-37f8029c\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00f3mo sumar con condiciones en Excel usando SUMAR.SI (1 Criterio)<\/h2>\n\n\n\n<p>Esta es la funci\u00f3n que usar\u00e1s cuando solo tengas <strong>una condici\u00f3n<\/strong> o pregunta. Por ejemplo:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00famame las ventas&#8230; <em>solo de Carlos<\/em>.<\/li>\n\n\n\n<li>S\u00famame los montos&#8230; <em>solo de la regi\u00f3n Norte<\/em>.<\/li>\n\n\n\n<li>S\u00famame los valores&#8230; <em>que sean mayores a 100<\/em>.<\/li>\n<\/ul>\n\n\n\n<p>La sintaxis b\u00e1sica es: <code>SUMAR.SI(rango, criterio, [rango_suma])<\/code><\/p>\n\n\n\n<p>Vamos a verlo paso a paso con el ejemplo de \u00absumar las ventas de Carlos\u00bb:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 1: Definir el Rango y Criterio (La Pregunta)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-21f11a40 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">El \u00abrango\u00bb y el \u00abcriterio\u00bb siempre van de la mano.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rango:<\/strong> \u00bfD\u00f3nde buscar\u00e1 Excel la condici\u00f3n? En nuestro caso, en la columna \u00abVendedor\u00bb.<\/li>\n\n\n\n<li><strong>Criterio:<\/strong> \u00bfQu\u00e9 estamos buscando exactamente? El texto \u00abCarlos\u00bb.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 2: El Criterio (\u00a1Siempre entre comillas!)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-5823c46f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h27m53s996.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h27m53s996.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h27m53s996.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h27m53s996.avif\" alt=\"Escribiendo el criterio &quot;Carlos&quot; entre comillas en la barra de f\u00f3rmulas de Excel.\" class=\"uag-image-27006\" width=\"890\" height=\"249\" title=\"Escribir Criterio SUMAR.SI Excel\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">Este es un consejo clave: en la mayor\u00eda de los casos, tu criterio debe ir entre comillas. Excel necesita entender que est\u00e1s buscando un texto espec\u00edfico.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Nuestra f\u00f3rmula se ver\u00eda as\u00ed: <code>SUMAR.SI(B2:B51, \"Carlos\", ...)<\/code><\/li>\n\n\n\n<li>(Donde B2:B51 es la columna de Vendedores).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 3: Definir el Rango Suma (El Resultado)<\/h3>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--60)\">Finalmente, le decimos a Excel qu\u00e9 columna debe sumar <em>si<\/em> encuentra coincidencias con \u00abCarlos\u00bb. Este es nuestro \u00abRango Suma\u00bb que identificamos al principio: la columna \u00abMonto\u00bb.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>F\u00f3rmula Completa:<\/strong> <code>SUMAR.SI(B2:B51, \"Carlos\", F2:F51)<\/code><\/li>\n\n\n\n<li>(Donde F2:F51 es la columna de Montos).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Truco: Usar \u00abDiferente de\u00bb<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-f01e3539 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h31m26s437.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h31m26s437.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h31m26s437.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h31m26s437.avif\" alt=\"Ejemplo de la funci\u00f3n SUMAR.SI de Excel usando el operador &quot;diferente de&quot; con el criterio &quot;<&gt;Ana&quot;.\" class=\"uag-image-27008\" width=\"845\" height=\"256\" title=\"Criterio Diferente De SUMAR.SI Excel\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">\u00bfY si tu jefe te pide \u00absumar todo <em>menos<\/em> las ventas de Ana\u00bb? Puedes usar el operador \u00abdiferente de\u00bb (<code>&lt;&gt;<\/code>).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>F\u00f3rmula:<\/strong> <code>SUMAR.SI(B2:B51,\"&lt;&gt;Ana\",F2:F51)<\/code><\/li>\n\n\n\n<li>Esto sumar\u00e1 todos los montos excepto los que correspondan a Ana.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-f8facec5\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Dominando M\u00faltiples Criterios: La Funci\u00f3n SUMAR.SI.CONJUNTO<\/h2>\n\n\n\n<p>Aqu\u00ed es donde la cosa se pone interesante. \u00bfQu\u00e9 pasa si te piden las ventas de <strong>Carlos<\/strong> <em>Y<\/em> que sean de la regi\u00f3n <strong>Centro<\/strong>?.<\/p>\n\n\n\n<p>Para eso, usamos <code>SUMAR.SI.CONJUNTO<\/code>. Esta funci\u00f3n te permite usar todas las condiciones que necesites.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">La Sintaxis Invertida: \u00a1Cuidado Aqu\u00ed!<\/h3>\n\n\n\n<p>\u00a1Mucha atenci\u00f3n! El orden de <code>SUMAR.SI.CONJUNTO<\/code> es diferente y es el error m\u00e1s com\u00fan. <strong>Aqu\u00ed, el Rango Suma se pone PRIMERO<\/strong>.<\/p>\n\n\n\n<p>Sintaxis: <code>SUMAR.SI.CONJUNTO(rango_suma, rango_criterio1, criterio1, [rango_criterio2, criterio2], ...)<\/code><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 1: El Rango Suma (Lo que quieres sumar)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-693c0fda wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Primero seleccionas la columna de los montos totales.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>SUMAR.SI.CONJUNTO(F2:F51, ...)<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 2: Rango Criterio 1 y Criterio 1 (Pregunta 1)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-da56d1ce wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h38m13s660.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h38m13s660.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h38m13s660.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h38m13s660.avif\" alt=\"Destacando el Rango Suma (columna Monto) como el primer argumento en la funci\u00f3n SUMAR.SI.CONJUNTO.\" class=\"uag-image-27012\" width=\"1968\" height=\"258\" title=\"Rango Suma en SUMAR.SI.CONJUNTO\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Ahora empezamos con las preguntas. No importa el orden.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rango 1:<\/strong> Columna \u00abVendedor\u00bb (F2:F51)<\/li>\n\n\n\n<li><strong>Criterio 1:<\/strong> <code>\"Carlos\"<\/code><\/li>\n\n\n\n<li>F\u00f3rmula: <code>SUMAR.SI.CONJUNTO(F2:F51,B2:B51, \"Carlos\", ...)<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 3: Rango Criterio 2 y Criterio 2 (Pregunta 2)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-ba92589a wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h41m48s329-1024x128.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h41m48s329.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h41m48s329.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h41m48s329-1024x128.avif\" alt=\"A\u00f1adiendo el segundo par de rango y criterio (Regi\u00f3n = Centro) en la f\u00f3rmula SUMAR.SI.CONJUNTO.\" class=\"uag-image-27013\" width=\"1024\" height=\"128\" title=\"SUMAR.SI.CONJUNTO Segundo Criterio\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">A\u00f1adimos la segunda condici\u00f3n.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rango 2:<\/strong> Columna \u00abRegi\u00f3n\u00bb (D2:D51)<\/li>\n\n\n\n<li><strong>Criterio 2:<\/strong> <code>\"Centro\"<\/code><\/li>\n\n\n\n<li><strong>F\u00f3rmula Completa:<\/strong> <code>SUMAR.SI.CONJUNTO(F2:F51,B2:B51,\"Carlos\",D2:D51, \"Centro\")<\/code><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Paso 4: A\u00f1adiendo m\u00e1s condiciones (\u00a1Fechas!)<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-2ad4f6b8 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h46m58s446-1024x100.avif ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h46m58s446.avif 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h46m58s446.avif 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h46m58s446-1024x100.avif\" alt=\"F\u00f3rmula completa de SUMAR.SI.CONJUNTO con tres criterios: Vendedor, Regi\u00f3n y Fecha mayor a.\" class=\"uag-image-27015\" width=\"1024\" height=\"100\" title=\"SUMAR.SI.CONJUNTO M\u00faltiples Criterios\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">La ventaja es que puedes seguir a\u00f1adiendo condiciones. \u00bfY si tambi\u00e9n tienen que ser del segundo semestre?<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rango 3:<\/strong> Columna \u00abFecha\u00bb (E2:E51)<\/li>\n\n\n\n<li><strong>Criterio 3:<\/strong> <code>\"&gt;=01\/06\/2025\"<\/code><\/li>\n\n\n\n<li><strong>F\u00f3rmula Final:<\/strong> <code>SUMAR.SI.CONJUNTO(F2:F51,B2:B51,\"Carlos\",D2:D51,\"Centro\",E2:E51,\"&gt;=01\/06\/2025\")<\/code><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-a4e8bb59\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">3 Consejos PRO para Mejorar tus F\u00f3rmulas<\/h2>\n\n\n\n<p>Dominar las funciones est\u00e1 bien, pero estos consejos te ayudar\u00e1n a trabajar de forma m\u00e1s eficiente.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. No solo Sumes: PROMEDIO y CONTAR<\/h3>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-4a12428f wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img loading=\"lazy\" decoding=\"async\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h50m30s072.png ,https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h50m30s072.png 780w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h50m30s072.png 360w\" sizes=\"auto, (max-width: 480px) 150px\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/vlcsnap-2025-11-17-10h50m30s072.png\" alt=\"Funciones relacionadas PROMEDIO.SI, PROMEDIO.SI.CONJUNTO y CONTAR.SI en la barra de f\u00f3rmulas de Excel.\" class=\"uag-image-27016\" width=\"2492\" height=\"562\" title=\"Funciones PROMEDIO.SI y CONTAR.SI\" loading=\"lazy\" role=\"img\"\/><\/figure><\/div>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Si entendiste este tutorial, \u00a1ya sabes usar dos funciones m\u00e1s!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>PROMEDIO.SI<\/strong> y <strong>PROMEDIO.SI.CONJUNTO<\/strong><\/li>\n\n\n\n<li><strong>CONTAR.SI<\/strong> y <strong>CONTAR.SI.CONJUNTO<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Funcionan con la <strong>exactamente la misma l\u00f3gica<\/strong> y sintaxis. Simplemente cambias el nombre de la funci\u00f3n para promediar o contar en lugar de sumar.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. El Secreto: Convierte tus datos en Tablas (Control + T)<\/h3>\n\n\n\n<p style=\"margin-top:var(--wp--preset--spacing--50)\">Este es el mejor consejo. En lugar de usar rangos fijos (como <code>A2:A10<\/code>), selecciona tus datos y presiona <strong>Control + T<\/strong> para convertirlos en una Tabla de Excel.<\/p>\n\n\n\n<p>\u00bfPor qu\u00e9?<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Legibilidad:<\/strong> Tu f\u00f3rmula cambiar\u00e1 de esto <code>SUMAR.SI(C2:C10, \"Carlos\", D2:D10)<\/code> a esto: <code>SUMAR.SI(Ventas[Vendedor], \"Carlos\", Ventas[Monto])<\/code>. \u00a1Es mucho m\u00e1s f\u00e1cil de leer!.<\/li>\n\n\n\n<li><strong>Autom\u00e1tico:<\/strong> Si a\u00f1ades nuevos datos (nuevas ventas) al final de la tabla, \u00a1la f\u00f3rmula los incluir\u00e1 autom\u00e1ticamente sin que tengas que modificarla!.<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-16982661\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo-0\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-b7e102\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-7fdadb ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-condiciones-Material-de-Apoyo.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-8a639400\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n: Ahora sabes c\u00f3mo calcular totales filtrados en Excel<\/h2>\n\n\n\n<p>\u00a1Felicidades! Has aprendido una de las habilidades m\u00e1s \u00fatiles en el an\u00e1lisis de datos. Ya puedes dejar de sumar manualmente y empezar a <strong>sumar con condiciones en Excel<\/strong> de forma autom\u00e1tica.<\/p>\n\n\n\n<p>Recuerda la regla de oro:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>1 Condici\u00f3n:<\/strong> Usa <code>SUMAR.SI<\/code>.<\/li>\n\n\n\n<li><strong>M\u00faltiples Condiciones:<\/strong> Usa <code>SUMAR.SI.CONJUNTO<\/code> (y recuerda poner el rango suma al principio).<\/li>\n<\/ul>\n\n\n\n<p>Y no olvides el consejo profesional: usa siempre <strong>Tablas (Control + T)<\/strong> para hacer tu vida m\u00e1s f\u00e1cil.<\/p>\n\n\n\n<div class=\"wp-block-uagb-separator uagb-block-91e6d3d9\"><div class=\"uagb-separator-spacing-wrapper\"><div class=\"wp-block-uagb-separator__inner\" style=\"--my-background-image:\"><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-6b51b24c uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b0c341cf \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfCu\u00e1l es la principal diferencia entre SUMAR.SI y SUMAR.SI.CONJUNTO?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Hay dos diferencias clave: 1) <code>SUMAR.SI<\/code> solo permite 1 criterio, mientras que <code>SUMAR.SI.CONJUNTO<\/code> permite m\u00faltiples criterios. 2) El orden de los argumentos: en <code>SUMAR.SI.CONJUNTO<\/code>, el rango que quieres sumar (<code>rango_suma<\/code>) va <em>primero<\/em>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-bd8df9e0 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPor qu\u00e9 mi f\u00f3rmula SUMAR.SI me da 0?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>El error m\u00e1s com\u00fan es olvidar las comillas <code>\"\"<\/code> en el criterio (ej. escribir <code>Carlos<\/code> en vez de <code>\"Carlos\"<\/code>). Revisa tambi\u00e9n que el rango de criterio y el rango de suma tengan el mismo tama\u00f1o.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3a2fced6 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPuedo usar SUMAR.SI con fechas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>\u00a1S\u00ed! Puedes usar operadores. Por ejemplo, para sumar todo lo posterior al 1 de enero de 2025, tu criterio ser\u00eda <code>\"&gt;01\/01\/2025\"<\/code>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-fd3e0d30 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo puedo sumar con condiciones en Excel si el criterio es \u00abno es igual a\u00bb?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Usa el operador \u00abdiferente de\u00bb, que es <code>&lt;&gt;<\/code>. Por ejemplo, <code>\"&lt;&gt;\"&amp;C2<\/code> para sumar todo lo que no sea igual al contenido de la celda C2, o <code>\"&lt;&gt;\"&amp;\"Ana\"<\/code>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c49eee5e \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfPor qu\u00e9 es tan importante usar Tablas (Control+T)?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Principalmente por dos razones: legibilidad (las f\u00f3rmulas usan nombres como <code>Ventas[Monto]<\/code> en lugar de <code>D2:D500<\/code>) y porque se actualizan autom\u00e1ticamente cuando a\u00f1ades nuevos datos, evitando errores.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Sumar con Condiciones en Excel Cuando empiezas a trabajar con datos, la funci\u00f3n =SUMA es tu mejor amiga. Pero, \u00bfqu\u00e9 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":26993,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[225,232,277,539,365,486],"class_list":["post-26992","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-facil","tag-gratis","tag-gratuito","tag-office","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>sumar con condiciones en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"sumar con condiciones en Excel\" \/>\n<meta property=\"og:description\" content=\"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-18T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292\"},\"headline\":\"sumar con condiciones en Excel\",\"datePublished\":\"2025-11-18T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\"},\"wordCount\":924,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif\",\"keywords\":[\"Excel\",\"Facil\",\"Gratis\",\"Gratuito\",\"office\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\",\"name\":\"sumar con condiciones en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif\",\"datePublished\":\"2025-11-18T17:30:00+00:00\",\"description\":\"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif\",\"width\":500,\"height\":375,\"caption\":\"aprende a sumar con muchos criterios\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"sumar con condiciones en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/daniel\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"sumar con condiciones en Excel - Dostin Hurtado","description":"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"sumar con condiciones en Excel","og_description":"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-11-18T17:30:00+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292"},"headline":"sumar con condiciones en Excel","datePublished":"2025-11-18T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/"},"wordCount":924,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif","keywords":["Excel","Facil","Gratis","Gratuito","office","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/","name":"sumar con condiciones en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif","datePublished":"2025-11-18T17:30:00+00:00","description":"\u00bfNecesitas sumar con condiciones en Excel? Aprende paso a paso a usar SUMAR.SI y SUMAR.SI.CONJUNTO para filtrar tus datos como un experto.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif","width":500,"height":375,"caption":"aprende a sumar con muchos criterios"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-con-condiciones-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"sumar con condiciones en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04-400x375.avif",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04.avif",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/11\/Sumar-con-Condiciones-en-Excel-Miniatura-04-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Sumar con Condiciones en Excel Cuando empiezas a trabajar con datos, la funci\u00f3n =SUMA es tu mejor amiga. Pero, \u00bfqu\u00e9 [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/26992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=26992"}],"version-history":[{"count":14,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/26992\/revisions"}],"predecessor-version":[{"id":27021,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/26992\/revisions\/27021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/26993"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=26992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=26992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=26992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}