{"id":12958,"date":"2023-03-11T22:12:27","date_gmt":"2023-03-11T22:12:27","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12958"},"modified":"2023-05-26T14:06:16","modified_gmt":"2023-05-26T14:06:16","slug":"la-funcion-contar-si-conjunto","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/","title":{"rendered":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h6>\u00bfPARA QU\u00c9 SIRVE LA FUNCI\u00d3N CONTAR.SI.CONJUNTO?<\/h6>\n<p>La funci\u00f3n <em><strong>CONTAR.SI.CONJUNTO<\/strong><\/em> en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados. Esta funci\u00f3n nos permite especificar hasta 127 criterios diferentes.<\/p><div id=\"excel-1478416952\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<hr \/>\n<h6 style=\"text-align: center;\"><strong>SINTAXIS DE LA FUNCI\u00d3N <em>CONTAR.SI.CONJUNTO<\/em><\/strong><\/h6>\n<pre style=\"text-align: center;\"><strong>=CONTAR.SI.CONJUNTO(rango_criterios1; criterio1; [rango_criterios2]; [criterio2])<\/strong><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12964\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-1.png\" alt=\"\" width=\"582\" height=\"335\" \/><\/p>\n<hr \/>\n<p>Vemos aqu\u00ed, que la funci\u00f3n \u00a0tiene dos argumentos obligatorios y los dem\u00e1s opcionales:<\/p>\n<ul>\n<li><strong>Rango_criterios1 (obligatorio):<\/strong> El rango de celdas que ser\u00e1 evaluado con el Criterio1.<\/li>\n<li><strong>Criterio1 (obligatorio):<\/strong> se refiere al criterio con que se evaluar\u00e1 el Rango_criterios1.<\/li>\n<li><strong>Rango_criterios2 (opcional):<\/strong> Es el rango de celdas que ser\u00e1 evaluado con el Criterio2.<\/li>\n<li><strong>Criterio2 (opcional):<\/strong> Es el criterio que evaluar\u00e1 el Rango_criterios2.<\/li>\n<\/ul>\n<h6>EJEMPLO DE LA FUNCI\u00d3N CONTAR.SI.CONJUNTO<\/h6>\n<p>Siguiendo con nuestra tabla de datos de viviendas deseamos conocer el total de las casas que ya se han vendido, pero en este caso adem\u00e1s le agregaremos otra condici\u00f3n, es decir las dos condiciones serian que estuviera vendida y adem\u00e1s que pertenezcan a la calle Castellana.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12970\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-3.png\" alt=\"\" width=\"883\" height=\"166\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-3.png 883w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-3-768x144.png 768w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/p>\n<p><strong>Paso 1:<\/strong> Lo primero que tendremos que escribir es el inicio de la f\u00f3rmula: <strong>=CONTAR.SI.CONJUNTO(<\/strong><\/p>\n<p><strong>Paso 2:<\/strong> A continuaci\u00f3n, vemos que los argumentos vienen en parejas, es decir, <em>Rango_criterios1<\/em>, <em>Criterio1<\/em>\u2026<em>Rango_criterios2<\/em>, <em>Criterio2<\/em>\u2026 y as\u00ed sucesivamente. Vamos con la primera pareja de argumentos:<\/p>\n<p><em>Rango_criterios1:<\/em> Puesto que lo que queremos saber es la cantidad de casas vendidas, nuestro primer argumento ser\u00e1 la columna <strong>Estado<\/strong>, y el <em>criterio1<\/em> concreto es la palabra <strong>\u201cVendido\u201d<\/strong>. <strong>=CONTAR.SI.CONJUNTO(G3:G8; \u00abVendido\u00bb;<\/strong><\/p>\n<p><strong>Paso 3:<\/strong> Ahora vamos con la segunda pareja de argumentos, que ser\u00edan <em>Rango_criterios2<\/em> y <em>Criterio2<\/em>. Para este ejemplo, puesto que lo que queremos saber es cuantas casas se han vendido en la calle Castellana, el <em>Rango_criterios2<\/em> es la columna en donde est\u00e1n las direcciones, y seguidamente el <em>Criterio2 <\/em>que en este caso es la expresi\u00f3n <strong>\u201cC\/Castellana\u201d<\/strong>. <strong>=CONTAR.SI.CONJUNTO(G3:G8; \u00abVendido\u00bb; C3:C8; \u00abC\/Castellana\u00bb<\/strong><\/p>\n<p><strong>Paso 4:<\/strong> Con esto ya podemos cerrar par\u00e9ntesis y tenemos configurada nuestra funci\u00f3n:<\/p>\n<p><strong>=CONTAR.SI.CONJUNTO(G3:G8; \u00abVendido\u00bb; C3:C8; \u00abC\/Castellana\u00bb) <\/strong>siendo el resultado 2 casas vendidas en la calle Castellana.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12966\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-2.png\" alt=\"\" width=\"959\" height=\"464\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-2.png 959w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar-si-conjunto-2-768x372.png 768w\" sizes=\"auto, (max-width: 959px) 100vw, 959px\" \/><\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p>Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u00bfPARA QU\u00c9 SIRVE LA &#8230; <a title=\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N CONTAR.SI.CONJUNTO\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12960,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[565,328,549,556],"tags":[561,560,566,575],"class_list":["post-12958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-estadisticas","category-excel","category-excel-intermedio","category-funciones-especiales","tag-contar-en-excel","tag-contar-si","tag-contar-si-conjunto","tag-funciones","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-11T22:12:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-26T14:06:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO\",\"datePublished\":\"2023-03-11T22:12:27+00:00\",\"dateModified\":\"2023-05-26T14:06:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\"},\"wordCount\":401,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png\",\"keywords\":[\"contar en excel\",\"contar si\",\"contar si conjunto\",\"funciones\"],\"articleSection\":[\"Estad\u00edsticas\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\",\"name\":\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png\",\"datePublished\":\"2023-03-11T22:12:27+00:00\",\"dateModified\":\"2023-05-26T14:06:16+00:00\",\"description\":\"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM","description":"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.","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:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM","og_description":"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-03-11T22:12:27+00:00","article_modified_time":"2023-05-26T14:06:16+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO","datePublished":"2023-03-11T22:12:27+00:00","dateModified":"2023-05-26T14:06:16+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/"},"wordCount":401,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png","keywords":["contar en excel","contar si","contar si conjunto","funciones"],"articleSection":["Estad\u00edsticas","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/","name":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO - EXCELFULLL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png","datePublished":"2023-03-11T22:12:27+00:00","dateModified":"2023-05-26T14:06:16+00:00","description":"La funci\u00f3n CONTAR.SI.CONJUNTO en Excel nos permite contar los elementos de un rango que cumplen con varios criterios especificados.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR.SI_.CONJUNTO.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-conjunto\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LA FUNCI\u00d3N CONTAR.SI.CONJUNTO"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=12958"}],"version-history":[{"count":12,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12958\/revisions"}],"predecessor-version":[{"id":13603,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12958\/revisions\/13603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12960"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}