{"id":12934,"date":"2023-03-07T23:04:56","date_gmt":"2023-03-07T23:04:56","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12934"},"modified":"2023-05-24T23:29:16","modified_gmt":"2023-05-24T23:29:16","slug":"la-funcion-contara-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/","title":{"rendered":"LA FUNCI\u00d3N CONTARA EN EXCEL"},"content":{"rendered":"<p>La funci\u00f3n <em><strong>CONTARA<\/strong><\/em> en Excel es una herramienta \u00fatil para contar el n\u00famero de celdas que no est\u00e1n vac\u00edas, es decir, que contienen cualquier tipo de informaci\u00f3n, incluidos los valores de error y texto vac\u00edo (\u00ab\u00bb). Esta funci\u00f3n se puede usar para contar el n\u00famero de celdas en una columna o fila o para contar el n\u00famero de celdas en una matriz de celdas.<\/p>\n<p>La funci\u00f3n <em><strong>CONTARA<\/strong><\/em> en Excel es muy similar a la funci\u00f3n <a href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\" target=\"_blank\" rel=\"noopener\"><em><strong>CONTAR<\/strong><\/em><\/a>, pero tiene una ventaja adicional; la funci\u00f3n <em><strong>CONTARA<\/strong><\/em> permite contar el n\u00famero de celdas que contienen texto en lugar de solo contar la cantidad de celdas que contienen n\u00fameros.<\/p><div id=\"excel-2454216912\" 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<p>Si dentro del rango hay una f\u00f3rmula que devuelve una cadena vac\u00eda, la funci\u00f3n <em><strong>CONTARA<\/strong><\/em> va a contar esa celda.<\/p>\n<hr \/>\n<h6 style=\"text-align: center;\"><strong>Sintaxis de la funci\u00f3n <em>CONTARA<\/em><\/strong><\/h6>\n<pre style=\"text-align: center;\"><strong>=CONTARA(valor1; \u00a0[valor2], \u2026)<\/strong><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12935\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/CONTARA.png\" alt=\"\" width=\"586\" height=\"333\" \/><\/p>\n<hr \/>\n<p>Solamente tiene dos argumentos que son:<\/p>\n<p><strong>valor1: (obligatorio):<\/strong> Primera celda o rango que contendr\u00e1 los valores a contar.<\/p>\n<p><strong>valor2: (opcional):<\/strong> El resto de las celdas que contendr\u00e1n los valores a contar. Pueden ser hasta 255 argumentos extra.<\/p>\n<h6>EJEMPLOS DE LA FUNCI\u00d3N CONTARA<\/h6>\n<p>Al igual que con la funci\u00f3n <a href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\" target=\"_blank\" rel=\"noopener\"><em><strong>CONTAR<\/strong><\/em><\/a> lo primero que tendremos que escribir es el inicio de la f\u00f3rmula: =CONTARA(<\/p>\n<p>Luego escribimos el primer argumento, que es el \u00fanico obligatorio. Para ello, seleccionaremos todos los valores de la tabla excepto los encabezados. Para finalizar, cerramos el par\u00e9ntesis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12937\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contara-enjemplo.png\" alt=\"\" width=\"774\" height=\"287\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contara-enjemplo.png 774w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contara-enjemplo-768x285.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/p>\n<p>Como podemos observar en estos ejemplos, excepto las celdas en blanco, la funci\u00f3n <em><strong>CONTARA<\/strong><\/em> tiene en cuenta todo, incluido ceros, textos y errores.<\/p>\n<p>La funci\u00f3n CONTARA en Excel ofrece la capacidad de contar el n\u00famero de celdas en un rango de manera r\u00e1pida y precisa. Esta funci\u00f3n tambi\u00e9n permite contar el n\u00famero de celdas que contienen texto en lugar de solo contar la cantidad de celdas que contienen n\u00fameros, lo que le permite obtener una idea m\u00e1s precisa de la cantidad de texto en una tabla de Excel.<\/p>\n<p>Por otro lado, si lo que queremos es contar celdas que cumplan con ciertas condiciones, usaremos la funci\u00f3n <em><strong><a href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-en-excel\/\" target=\"_blank\" rel=\"noopener\">CONTAR.SI<\/a><\/strong><\/em> o <em><strong>CONTAR.SI.CONJUNTO<\/strong><\/em>.<\/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>La funci\u00f3n CONTARA en Excel &#8230; <a title=\"LA FUNCI\u00d3N CONTARA EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N CONTARA EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12938,"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,563,575],"class_list":["post-12934","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-contara","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 CONTARA EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.\" \/>\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-contara-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"LA FUNCI\u00d3N CONTARA EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\" \/>\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-07T23:04:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-24T23:29:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.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-contara-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N CONTARA EN EXCEL\",\"datePublished\":\"2023-03-07T23:04:56+00:00\",\"dateModified\":\"2023-05-24T23:29:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\"},\"wordCount\":406,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png\",\"keywords\":[\"contar en excel\",\"contara\",\"funciones\"],\"articleSection\":[\"Estad\u00edsticas\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\",\"name\":\"LA FUNCI\u00d3N CONTARA EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png\",\"datePublished\":\"2023-03-07T23:04:56+00:00\",\"dateModified\":\"2023-05-24T23:29:16+00:00\",\"description\":\"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N CONTARA EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#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 CONTARA EN EXCEL\"}]},{\"@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 CONTARA EN EXCEL - EXCELFULL.COM","description":"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.","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-contara-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N CONTARA EN EXCEL - EXCELFULL.COM","og_description":"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-03-07T23:04:56+00:00","article_modified_time":"2023-05-24T23:29:16+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.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-contara-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N CONTARA EN EXCEL","datePublished":"2023-03-07T23:04:56+00:00","dateModified":"2023-05-24T23:29:16+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/"},"wordCount":406,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png","keywords":["contar en excel","contara","funciones"],"articleSection":["Estad\u00edsticas","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/","name":"LA FUNCI\u00d3N CONTARA EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png","datePublished":"2023-03-07T23:04:56+00:00","dateModified":"2023-05-24T23:29:16+00:00","description":"La funci\u00f3n CONTARA en Excel es \u00fatil para contar el n\u00famero de celdas que no estan vac\u00edas, y que contienen cualquier tipo de informaci\u00f3n.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTARA-EN-EXCEL.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N CONTARA EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contara-en-excel\/#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 CONTARA EN EXCEL"}]},{"@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\/12934","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=12934"}],"version-history":[{"count":9,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12934\/revisions"}],"predecessor-version":[{"id":13579,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12934\/revisions\/13579"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12938"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}