{"id":1621,"date":"2013-03-05T09:00:44","date_gmt":"2013-03-05T14:00:44","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/?p=1621"},"modified":"2013-03-05T09:00:44","modified_gmt":"2013-03-05T14:00:44","slug":"funcion-contar-excel","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/","title":{"rendered":"Funci\u00f3n CONTAR Excel"},"content":{"rendered":"<h2>Definici\u00f3n &#8211; Qu\u00e9 hace?<\/h2>\n<p>La funci\u00f3n CONTAR es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. CONTAR se utiliza para determinar el n\u00famero total de elementos que contiene un conjunto o arreglo de celdas cuyo contenido sean n\u00fameros o una representaci\u00f3n de un n\u00famero. Por ejemplo, un n\u00famero entre comillas, como &#8220;1&#8221;<\/p>\n<h2>Sintaxis<\/h2>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\" alt=\"Funcion CONTAR Excel\" width=\"598\" height=\"123\" \/><\/p>\n<h2>Argumentos<\/h2>\n<ul>\n<li>Val1 Argumento requerido.<\/li>\n<li>Val2,&#8230; ValN son argumentos opcionales.<\/li>\n<\/ul>\n<p>Los argumentos de la funci\u00f3n CONTAR pueden ser n\u00fameros, rangos con valores num\u00e9ricos, matrices o referencias de celdas. El m\u00e1ximo n\u00famero de argumentos que se pueden colocar en la funci\u00f3n CONTAR depende de la versi\u00f3n de Excel que est\u00e9s utilizando. En Excel 2007 se pueden ingresar hasta 255 argumentos.<\/p>\n<p>Los argumentos pueden contener o hacer referencia a una variedad de diferentes tipos de datos, pero s\u00f3lo se cuentan los n\u00fameros.<\/p>\n<p>Si el argumento es una matriz o una referencia, s\u00f3lo se utilizar\u00e1n los n\u00fameros contenidos en la matriz o en la referencia. Se pasar\u00e1n por alto las celdas vac\u00edas, los valores l\u00f3gicos o el texto contenidos en la matriz o en la referencia.<\/p>\n<p>Si el argumento contiene celdas vac\u00edas, valores l\u00f3gicos o de texto, la funci\u00f3n CONTAR devuelve 0.<\/p>\n<p>Si deseas incluir valores l\u00f3gicos o de texto utiliza la funci\u00f3n <b>CONTARA<\/b><\/p>\n<p>Si deseas contar s\u00f3lo n\u00fameros que cumplan con determinados criterios, utiliza la funci\u00f3n <b>CONTAR.SI<\/b> o la funci\u00f3n <b>CONTAR.SI.CONJUNTO<\/b><\/p>\n<h2>Ejemplos de sintaxis de la funci\u00f3n CONTAR<\/h2>\n<table id=\"tblog\">\n<tbody>\n<tr>\n<td width=\"150\"><strong>Tipo de Argumento<\/strong><\/td>\n<td width=\"150\"><strong>Ejemplo<\/strong><\/td>\n<td width=\"300\"><strong>Explicaci\u00f3n<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Referencia a Celdas<\/td>\n<td>=CONTAR(A1; B1)<\/td>\n<td>Cuenta cuantos n\u00fameros existen en las celdas A1 y B1<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Rangos<\/td>\n<td>=CONTAR(A1:A10)<\/td>\n<td>Cuenta cuantos n\u00fameros existen desde las celdas A1 a A10<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Columnas<\/td>\n<td>=CONTAR(C:C)<\/td>\n<td>Cuenta cuantos n\u00fameros existen en la columna C<\/td>\n<\/tr>\n<tr>\n<td>Referencia a Filas<\/td>\n<td>=CONTAR(1:1)<\/td>\n<td>Cuenta cuantos n\u00fameros existen en la fila 1<\/td>\n<\/tr>\n<tr>\n<td>Multiple Columnas\/Filas<\/td>\n<td>=CONTAR(A1:A10, C1:C10)<\/td>\n<td>Cuenta cuantos n\u00fameros existen desde las celdas A1 a A10 y desde C1 a C10<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Ejemplos de uso de la funci\u00f3n CONTAR<\/h2>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter\" src=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-02.jpg\" alt=\"Funcion CONTAR\" width=\"571\" height=\"187\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Definici\u00f3n &#8211; Qu\u00e9 hace?<br \/>\nLa funci\u00f3n CONTAR es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. CONTAR se utiliza para determinar el n\u00famero total de elementos que contiene un conjunto o arreglo de celdas cuyo contenido sean n\u00fameros o una representaci\u00f3n de un n\u00famero. Por ejemplo, un n\u00famero entre comillas, como &#8220;1&#8221;<br \/>\nSintaxis<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[185],"tags":[182],"class_list":["post-1621","post","type-post","status-publish","format-standard","hentry","category-formulas-funciones","tag-formulas-funciones-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Funci\u00f3n CONTAR Excel - CAVSI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n CONTAR Excel - CAVSI\" \/>\n<meta property=\"og:description\" content=\"Definici\u00f3n - Qu\u00e9 hace? La funci\u00f3n CONTAR es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. CONTAR se utiliza para determinar el n\u00famero total de elementos que contiene un conjunto o arreglo de celdas cuyo contenido sean n\u00fameros o una representaci\u00f3n de un n\u00famero. Por ejemplo, un n\u00famero entre comillas, como &quot;1&quot; Sintaxis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-05T14:00:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"Funci\u00f3n CONTAR Excel\",\"datePublished\":\"2013-03-05T14:00:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\"},\"wordCount\":367,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\",\"keywords\":[\"F\u00f3rmulas y Funciones de Excel\"],\"articleSection\":[\"Excel: Formulas y Funciones\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\",\"name\":\"Funci\u00f3n CONTAR Excel - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\",\"datePublished\":\"2013-03-05T14:00:44+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"name\":\"CAVSI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\",\"name\":\"CAVSI\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"width\":300,\"height\":70,\"caption\":\"CAVSI\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.cavsi.com\/espanol\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n CONTAR Excel - CAVSI","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:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n CONTAR Excel - CAVSI","og_description":"Definici\u00f3n - Qu\u00e9 hace? La funci\u00f3n CONTAR es una de las funciones estad\u00edsticas de m\u00e1s utilizadas en Excel. CONTAR se utiliza para determinar el n\u00famero total de elementos que contiene un conjunto o arreglo de celdas cuyo contenido sean n\u00fameros o una representaci\u00f3n de un n\u00famero. Por ejemplo, un n\u00famero entre comillas, como \"1\" Sintaxis","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/","og_site_name":"CAVSI","article_published_time":"2013-03-05T14:00:44+00:00","og_image":[{"url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"Funci\u00f3n CONTAR Excel","datePublished":"2013-03-05T14:00:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/"},"wordCount":367,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg","keywords":["F\u00f3rmulas y Funciones de Excel"],"articleSection":["Excel: Formulas y Funciones"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/","name":"Funci\u00f3n CONTAR Excel - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg","datePublished":"2013-03-05T14:00:44+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/funcion-contar-excel\/#primaryimage","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/funciones-estadisticas\/funcion-contar-01.jpg"},{"@type":"WebSite","@id":"https:\/\/www.cavsi.com\/espanol\/#website","url":"https:\/\/www.cavsi.com\/espanol\/","name":"CAVSI","description":"","publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.cavsi.com\/espanol\/#organization","name":"CAVSI","url":"https:\/\/www.cavsi.com\/espanol\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","width":300,"height":70,"caption":"CAVSI"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.cavsi.com\/espanol"]}]}},"_links":{"self":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/1621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/comments?post=1621"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/1621\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=1621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=1621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=1621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}