{"id":12919,"date":"2023-03-03T12:42:22","date_gmt":"2023-03-03T12:42:22","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=12919"},"modified":"2023-05-24T23:20:07","modified_gmt":"2023-05-24T23:20:07","slug":"la-funcion-contar-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/","title":{"rendered":"LA FUNCI\u00d3N CONTAR EN EXCEL"},"content":{"rendered":"<p>La funci\u00f3n <em><strong>CONTAR<\/strong><\/em> en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico. Estos n\u00fameros pueden ser enteros, decimales, porcentaje, fecha, etc.<\/p>\n<p>La funci\u00f3n <em><strong>CONTAR<\/strong><\/em> es una de las funciones m\u00e1s utilizadas de Excel, junto con <em><strong>CONTARA<\/strong><\/em> y <a href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-en-excel\/\" target=\"_blank\" rel=\"noopener\"><em><strong>CONTAR.SI<\/strong><\/em><\/a><\/p><div id=\"excel-1936264108\" 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\u00f3n <em>CONTAR<\/em><\/strong><\/h6>\n<pre style=\"text-align: center;\"><strong>=CONTAR(valor1; \u00a0[valor2], \u2026)<\/strong><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12920\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/contar.png\" alt=\"\" width=\"588\" height=\"331\" \/><\/p>\n<hr \/>\n<p>Solamente tiene dos argumentos que son:<\/p>\n<ol>\n<li><strong>valor1 (obligatorio):<\/strong> Indica el primer elemento, es decir la referencia de celda o rango en el que deseamos contar los n\u00fameros.<\/li>\n<li><strong>valor2 (opcional):<\/strong> Nos permite poner hasta 255 elementos, celdas de referencia, o rangos adicionales en los que deseamos contar n\u00fameros.<\/li>\n<\/ol>\n<p style=\"padding-left: 40px;\">Los argumentos pueden contener o hacer referencia a una variedad de diferentes tipos de datos, pero solo se cuentan los n\u00fameros.<\/p>\n<h6>EJEMPLO DE LA FUNCI\u00d3N CONTAR<\/h6>\n<p>Podemos aplicar la funci\u00f3n <em><strong>CONTAR<\/strong><\/em> escribiendo directamente sobre la celda donde queremos el resultado o con el cuadro de di\u00e1logo, si la insertamos desde el buscador de funciones. (Todas las funciones se pueden aplicar de estas dos formas).<\/p>\n<p>C\u00f3mo la funci\u00f3n es muy f\u00e1cil de usar, la aplicaremos directamente sobre la celda escribiendo su sintaxis.<\/p>\n<p>Para el siguiente ejemplo tenemos tres columnas de datos: <strong>nombre del estudiante<\/strong>, <strong>calificaci\u00f3n<\/strong> y <strong>estatus<\/strong>. Con la funci\u00f3n <em><strong>CONTAR<\/strong><\/em> de Excel queremos saber cu\u00e1ntos estudiantes se presentaron al examen.<\/p>\n<p><strong>Paso 1:<\/strong> Lo primero que tendremos que escribir es el inicio de la f\u00f3rmula: =CONTAR(<\/p>\n<p><strong>Paso 2:<\/strong> Ahora solo necesitamos escribir el primer argumento, que como hemos comentado, es el \u00fanico obligatorio. Para ello, seleccionaremos todos los valores de la tabla excepto los encabezados. En este caso, vamos a hacer el ejercicio con la columna <strong>Calificaci\u00f3n<\/strong>, que es la columna con n\u00fameros.<\/p>\n<p><strong>Paso 3:<\/strong> Para finalizar, cerramos el par\u00e9ntesis y nos tiene que quedar la siguiente f\u00f3rmula: <strong>=CONTAR(C5:C19)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12922\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/funcion-contar.png\" alt=\"funci\u00f3n contar\" width=\"856\" height=\"440\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/funcion-contar.png 856w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/funcion-contar-768x395.png 768w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/p>\n<p>El resultado que nos da es <strong>\u201c15\u201d<\/strong>, por lo tanto, 15 estudiantes se han presentado al examen.<\/p>\n<p>En el caso de que intentemos realizar la cuenta con la columna que contiene el nombre del estudiante o el estatus, el resultado ser\u00e1 <strong>cero (0)<\/strong>, ya que, como lo explicamos al inicio, esta funci\u00f3n es para contar celdas en Excel que contengan n\u00fameros.<\/p>\n<p>La funci\u00f3n<em> <strong>CONTAR<\/strong><\/em> no sirve para contar n\u00fameros que cumplan uno o varios criterios, por ejemplo, cuantos estudiantes han aprobado y cuantos han reprobado; para saber esto necesitaremos utilizar la funci\u00f3n <a href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-si-en-excel\/\" target=\"_blank\" rel=\"noopener\"><em><strong>CONTAR.SI<\/strong><\/em><\/a> o CONTAR.SI.CONJUNTO que veremos en las pr\u00f3ximas lecciones.<\/p>\n<p>Como vimos el dia de hoy, la funci\u00f3n <em><strong>CONTAR<\/strong><\/em> en Excel es f\u00e1cil de usar. Esta funci\u00f3n nos permite contar el n\u00famero de celdas en una hoja de c\u00e1lculo con s\u00f3lo unos pocos clics. Esto hace que sea mucho m\u00e1s f\u00e1cil realizar c\u00e1lculos y estad\u00edsticas en Excel.<\/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 CONTAR en Excel &#8230; <a title=\"LA FUNCI\u00d3N CONTAR EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LA FUNCI\u00d3N CONTAR EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":12930,"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":[562,561,575],"class_list":["post-12919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-funciones-estadisticas","category-excel","category-excel-intermedio","category-funciones-especiales","tag-contar","tag-contar-en-excel","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 EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.\" \/>\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-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 CONTAR EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/la-funcion-contar-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-03T12:42:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-24T23:20:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-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-contar-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LA FUNCI\u00d3N CONTAR EN EXCEL\",\"datePublished\":\"2023-03-03T12:42:22+00:00\",\"dateModified\":\"2023-05-24T23:20:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\"},\"wordCount\":517,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png\",\"keywords\":[\"contar\",\"contar en excel\",\"funciones\"],\"articleSection\":[\"Estad\u00edsticas\",\"Excel\",\"Excel Intermedio\",\"Funciones Especiales\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\",\"name\":\"LA FUNCI\u00d3N CONTAR EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png\",\"datePublished\":\"2023-03-03T12:42:22+00:00\",\"dateModified\":\"2023-05-24T23:20:07+00:00\",\"description\":\"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LA FUNCI\u00d3N CONTAR EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/la-funcion-contar-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 CONTAR 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 CONTAR EN EXCEL - EXCELFULL.COM","description":"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.","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-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LA FUNCI\u00d3N CONTAR EN EXCEL - EXCELFULL.COM","og_description":"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.","og_url":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-03-03T12:42:22+00:00","article_modified_time":"2023-05-24T23:20:07+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-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-contar-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LA FUNCI\u00d3N CONTAR EN EXCEL","datePublished":"2023-03-03T12:42:22+00:00","dateModified":"2023-05-24T23:20:07+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/"},"wordCount":517,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png","keywords":["contar","contar en excel","funciones"],"articleSection":["Estad\u00edsticas","Excel","Excel Intermedio","Funciones Especiales"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/","url":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/","name":"LA FUNCI\u00d3N CONTAR EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png","datePublished":"2023-03-03T12:42:22+00:00","dateModified":"2023-05-24T23:20:07+00:00","description":"La funci\u00f3n CONTAR en Excel nos permite contabilizar la cantidad de celdas que contienen n\u00fameros dentro de un rango espec\u00edfico.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/03\/LA-FUNCION-CONTAR-EN-EXCEL.png","width":1280,"height":720,"caption":"LA FUNCI\u00d3N CONTAR EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/la-funcion-contar-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 CONTAR 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\/12919","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=12919"}],"version-history":[{"count":14,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12919\/revisions"}],"predecessor-version":[{"id":13576,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/12919\/revisions\/13576"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/12930"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=12919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=12919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=12919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}