{"id":4627,"date":"2018-05-19T12:00:57","date_gmt":"2018-05-19T17:00:57","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=4627"},"modified":"2025-04-05T16:26:18","modified_gmt":"2025-04-05T21:26:18","slug":"contar-y-sumar-conjunto","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/","title":{"rendered":"Contar y Sumar Conjunto en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-como-contar-y-sumar-conjunto-en-excel-con-multiples-criterios\"><span style=\"vertical-align: inherit;\"><span style=\"vertical-align: inherit;\">C\u00f3mo Contar y Sumar Conjunto en Excel con M\u00faltiples Criterios<\/span><\/span><\/h1>\n\n\n\n<p>Si trabajas con hojas de c\u00e1lculo, seguramente en alg\u00fan momento has necesitado aplicar filtros avanzados para contar o sumar datos. Aqu\u00ed es donde entra en juego la frase clave <strong>Contar y Sumar Conjunto en Excel<\/strong>. En este post aprender\u00e1s a usar las funciones <code>CONTAR.SI.CONJUNTO<\/code> y <code>SUMAR.SI.CONJUNTO<\/code> para analizar tus datos con precisi\u00f3n. Este contenido est\u00e1 basado en un tutorial en video de Dostin Hurtado, donde se explica paso a paso c\u00f3mo dominar estas potentes funciones.<\/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=\"Sumar.Si y Contar.Si con Varios Criterios en Excel - Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/saIFcp7HVrA?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<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-927790\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-19c1a1 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/tutoriales_excel\/sumar_contar_conjunto.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<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es Contar y Sumar Conjunto en Excel?<\/h2>\n\n\n\n<p>Excel ofrece herramientas muy poderosas para realizar an\u00e1lisis de datos. Entre ellas, destacan:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CONTAR.SI.CONJUNTO<\/strong>: cuenta celdas que cumplen m\u00faltiples condiciones.<\/li>\n\n\n\n<li><strong>SUMAR.SI.CONJUNTO<\/strong>: suma valores solo si cumplen varios criterios establecidos.<\/li>\n<\/ul>\n\n\n\n<p>Estas funciones son especialmente \u00fatiles para bases de datos grandes, an\u00e1lisis de ventas, control de inventarios y m\u00e1s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00f3mo usar la funci\u00f3n CONTAR.SI.CONJUNTO para Contar Conjuntos en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d8dfdf\" data-has-transparency=\"true\" style=\"--dominant-color: #d8dfdf;\" fetchpriority=\"high\" decoding=\"async\" width=\"757\" height=\"80\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-70.png\" alt=\"\" class=\"wp-image-25173 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-70.png 757w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-70-300x32.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-70-600x63.avif 600w\" sizes=\"(max-width: 757px) 100vw, 757px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfC\u00f3mo funciona CONTAR.SI.CONJUNTO?<\/h3>\n\n\n\n<p>Esta funci\u00f3n permite contar celdas bas\u00e1ndose en varios criterios simult\u00e1neamente. Su estructura b\u00e1sica es:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=CONTAR.SI.CONJUNTO(rango_criterio1, criterio1, rango_criterio2, criterio2, ...)<br><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Ejemplo pr\u00e1ctico con m\u00faltiples condiciones<\/h3>\n\n\n\n<p>Supongamos que quieres contar cu\u00e1ntas veces un producto fue vendido por un vendedor espec\u00edfico en una ciudad determinada:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=CONTAR.SI.CONJUNTO(A2:A100, \"Manzanas\", B2:B100, \"Carlos\", C2:C100, \"Bogot\u00e1\")<br><\/code><\/pre>\n\n\n\n<p>Esta f\u00f3rmula cuenta cu\u00e1ntas veces <strong>Carlos<\/strong> vendi\u00f3 <strong>manzanas<\/strong> en <strong>Bogot\u00e1<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00f3mo aplicar SUMAR.SI.CONJUNTO para Sumar Conjuntos en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d2dadc\" data-has-transparency=\"true\" style=\"--dominant-color: #d2dadc;\" decoding=\"async\" width=\"647\" height=\"69\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-69.png\" alt=\"\" class=\"wp-image-25172 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-69.png 647w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-69-300x32.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/image-69-600x64.avif 600w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfQu\u00e9 hace SUMAR.SI.CONJUNTO?<\/h3>\n\n\n\n<p>Esta funci\u00f3n suma valores bas\u00e1ndose en uno o m\u00e1s criterios. Su sintaxis es:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SUMAR.SI.CONJUNTO(rango_suma, rango_criterio1, criterio1, ...)<br><\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Ejemplo de Sumar Conjuntos con m\u00faltiples filtros<\/h3>\n\n\n\n<p>Imagina que deseas saber cu\u00e1nto vendi\u00f3 en total un empleado en una regi\u00f3n espec\u00edfica:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SUMAR.SI.CONJUNTO(D2:D100, A2:A100, \"Carlos\", B2:B100, \"Bogot\u00e1\")<br><\/code><\/pre>\n\n\n\n<p>Aqu\u00ed, se suma todo lo que vendi\u00f3 <strong>Carlos<\/strong> en <strong>Bogot\u00e1<\/strong>, donde la columna D tiene los valores de ventas.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Diferencias clave entre SUMAR.SI y Contar y Sumar Conjunto en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Funci\u00f3n<\/th><th>\u00bfM\u00faltiples criterios?<\/th><th>Aplicaci\u00f3n com\u00fan<\/th><\/tr><\/thead><tbody><tr><td><code>SUMAR.SI<\/code><\/td><td>No<\/td><td>Un solo criterio de suma<\/td><\/tr><tr><td><code>SUMAR.SI.CONJUNTO<\/code><\/td><td>S\u00ed<\/td><td>Varias condiciones juntas<\/td><\/tr><tr><td><code>CONTAR.SI<\/code><\/td><td>No<\/td><td>Contar con una sola condici\u00f3n<\/td><\/tr><tr><td><code>CONTAR.SI.CONJUNTO<\/code><\/td><td>S\u00ed<\/td><td>Contar con m\u00faltiples filtros<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Errores comunes al usar Contar y Sumar Conjunto en Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u274c <strong>Confundir el orden de los argumentos<\/strong>: Siempre inicia con el rango de suma o de conteo, seguido de los criterios.<\/li>\n\n\n\n<li>\u274c <strong>No usar rangos del mismo tama\u00f1o<\/strong>: Todos los rangos deben tener el mismo n\u00famero de celdas.<\/li>\n\n\n\n<li>\u274c <strong>Errores de formato<\/strong>: Aseg\u00farate de que los criterios coincidan en tipo (texto, n\u00famero, etc.).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Consejos para Dominar Contar y Sumar Conjunto en Excel<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Usa filtros antes de aplicar f\u00f3rmulas para verificar los datos.<\/li>\n\n\n\n<li>Aseg\u00farate de que todos los rangos est\u00e9n bien alineados.<\/li>\n\n\n\n<li>Combina con validaci\u00f3n de datos o tablas din\u00e1micas para an\u00e1lisis m\u00e1s robustos.<\/li>\n<\/ol>\n\n\n\n<p>\u00a1\ud83d\udea8 Atenci\u00f3n! Si est\u00e1s buscando licencias originales de Windows y Office a precios accesibles, <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> es tu mejor opci\u00f3n \ud83d\udcbb\ud83d\udd11. No solo ofrecen productos 100% leg\u00edtimos, sino que adem\u00e1s puedes aprovechar <strong>descuentos exclusivos<\/strong> utilizando el c\u00f3digo <strong>DH66<\/strong> al momento de tu compra \ud83d\uded2\ud83d\udcb8. \u00a1No pierdas la oportunidad de ahorrar mientras obtienes software confiable y permanente! \u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Las funciones <strong>Contar y Sumar Conjunto en Excel<\/strong> son herramientas fundamentales para quienes trabajan con datos complejos. Ya sea para controlar inventarios, analizar ventas o simplemente filtrar informaci\u00f3n de forma eficiente, dominar <code>SUMAR.SI.CONJUNTO<\/code> y <code>CONTAR.SI.CONJUNTO<\/code> te dar\u00e1 una gran ventaja en tu flujo de trabajo.<\/p>\n\n\n\n<p>\u00bfQuieres dominar Excel de una vez por todas y destacar en tu trabajo o estudios? \ud83d\udcca\ud83d\udcbc \u00a1Este es el momento perfecto para hacerlo! Te recomiendo inscribirte en un <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\">Curso de Excel<\/a> <\/strong>completo y pr\u00e1ctico<strong>,<\/strong> donde aprender\u00e1s desde lo m\u00e1s b\u00e1sico hasta funciones avanzadas que realmente marcan la diferencia. \ud83d\udd0d\ud83d\udcc8 No importa tu nivel, este curso est\u00e1 dise\u00f1ado para ayudarte a mejorar tus habilidades paso a paso, con ejemplos reales y ejercicios f\u00e1ciles de seguir. \u2705\ud83d\udca1 \u00a1No dejes pasar esta oportunidad de potenciar tu perfil profesional y ahorrar tiempo con las herramientas que Excel te ofrece! \u23f1\ufe0f\ud83d\ude80 \u00a1Empieza hoy y lleva tu productividad al siguiente nivel! \ud83e\udde0\ud83d\udd25<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-379da906 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-1e75a4f1 \" 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>\u00bfQu\u00e9 versi\u00f3n de Excel necesito para usar estas funciones?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Estas funciones est\u00e1n disponibles desde Excel 2007 en adelante.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6113d33d \" 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 criterios de texto y n\u00fameros al mismo tiempo?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes combinar criterios de distintos tipos, siempre que los rangos est\u00e9n bien definidos.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-2b425d05 \" 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>\u00bfFunciona con celdas vac\u00edas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, pero puede alterar los resultados si no se manejan correctamente.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-af1691e2 \" 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>\u00bfQu\u00e9 pasa si uno de los rangos tiene un tama\u00f1o diferente?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si los rangos no tienen el mismo n\u00famero de celdas, Excel devolver\u00e1 un error. Aseg\u00farate de que todos los rangos involucrados en la f\u00f3rmula tengan la misma longitud para evitar problemas.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-560c2115 \" 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 referencias a otras hojas en estas funciones?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes utilizar referencias a otras hojas dentro de las funciones <code>SUMAR.SI.CONJUNTO<\/code> y <code>CONTAR.SI.CONJUNTO<\/code>. Solo debes asegurarte de que las rutas sean correctas, por ejemplo:<br><code>=SUMAR.SI.CONJUNTO(Hoja2!D2:D100, Hoja2!A2:A100, \"Carlos\")<\/code> cv<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.<\/p>\n","protected":false},"author":4,"featured_media":4890,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","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,258,265,486],"class_list":["post-4627","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-funcion-contar-si","tag-funcion-sumar-si","tag-tutorial","post_format-post-format-video"],"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>Contar y Sumar Conjunto en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.\" \/>\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\/contar-y-sumar-conjunto\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Contar y Sumar Conjunto en Excel de Forma Efectiva\" \/>\n<meta property=\"og:description\" content=\"Aprende a Contar y Sumar Conjunto en Excel y domina las funciones para un an\u00e1lisis de datos m\u00e1s efectivo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-19T17:00:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-05T21:26:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\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:title\" content=\"Contar y Sumar Conjunto en Excel de Forma Efectiva\" \/>\n<meta name=\"twitter:description\" content=\"Descubre c\u00f3mo Contar y Sumar Conjunto en Excel puede facilitar tus an\u00e1lisis de datos con ejemplos pr\u00e1cticos y tutoriales.\" \/>\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=\"4 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\/contar-y-sumar-conjunto\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Contar y Sumar Conjunto en Excel\",\"datePublished\":\"2018-05-19T17:00:57+00:00\",\"dateModified\":\"2025-04-05T21:26:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\"},\"wordCount\":714,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg\",\"keywords\":[\"Excel\",\"Funcion contar.si\",\"Funcion sumar.si\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\",\"name\":\"Contar y Sumar Conjunto en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg\",\"datePublished\":\"2018-05-19T17:00:57+00:00\",\"dateModified\":\"2025-04-05T21:26:18+00:00\",\"description\":\"Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg\",\"width\":500,\"height\":376,\"caption\":\"Funciones Sumar.si y contar.si en Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Contar y Sumar Conjunto 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\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Contar y Sumar Conjunto en Excel - Dostin Hurtado","description":"Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.","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\/contar-y-sumar-conjunto\/","og_locale":"es_ES","og_type":"article","og_title":"Contar y Sumar Conjunto en Excel de Forma Efectiva","og_description":"Aprende a Contar y Sumar Conjunto en Excel y domina las funciones para un an\u00e1lisis de datos m\u00e1s efectivo.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/","og_site_name":"Dostin Hurtado","article_published_time":"2018-05-19T17:00:57+00:00","article_modified_time":"2025-04-05T21:26:18+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Contar y Sumar Conjunto en Excel de Forma Efectiva","twitter_description":"Descubre c\u00f3mo Contar y Sumar Conjunto en Excel puede facilitar tus an\u00e1lisis de datos con ejemplos pr\u00e1cticos y tutoriales.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Contar y Sumar Conjunto en Excel","datePublished":"2018-05-19T17:00:57+00:00","dateModified":"2025-04-05T21:26:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/"},"wordCount":714,"commentCount":1,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg","keywords":["Excel","Funcion contar.si","Funcion sumar.si","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/","name":"Contar y Sumar Conjunto en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg","datePublished":"2018-05-19T17:00:57+00:00","dateModified":"2025-04-05T21:26:18+00:00","description":"Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg","width":500,"height":376,"caption":"Funciones Sumar.si y contar.si en Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/contar-y-sumar-conjunto\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Contar y Sumar Conjunto 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\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2018\/05\/sumar_contar_criterios-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":1,"uagb_excerpt":"Aprende Contar y Sumar Conjunto en Excel f\u00e1cilmente con este tutorial. Analiza tus datos con m\u00faltiples criterios y domina Excel.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4627","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=4627"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4627\/revisions"}],"predecessor-version":[{"id":25174,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/4627\/revisions\/25174"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/4890"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=4627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=4627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=4627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}