{"id":81,"date":"2023-11-17T07:39:08","date_gmt":"2023-11-17T07:39:08","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/"},"modified":"2023-12-25T10:24:37","modified_gmt":"2023-12-25T10:24:37","slug":"contar-si-es-menor-que","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/","title":{"rendered":"\u00bfc\u00f3mo contar celdas menores que un valor particular?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-958919245\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, si desea contar celdas que tienen un valor menor o menor que un valor particular, debe usar la funci\u00f3n CONTAR.SI. Con esta funci\u00f3n, puede especificar un rango de valores para contar y luego una cantidad de criterios para contar las celdas siguientes.<\/p>\n<p> En este tutorial de f\u00f3rmulas, veremos algunos ejemplos para entenderla.<\/p>\n<h2 class=\"wp-block-heading\"> CONTAR.SI para contar menos celdas<\/h2>\n<p> En el siguiente ejemplo, tenemos una lista de valores en la columna (una lista de 1000 n\u00fameros). Ahora necesitas contar las celdas que tienen menos de 45. Como dije, necesitas usar CONTAR.SI, escribiremos esta f\u00f3rmula en la celda B1. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67115\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"lista de valores\" width=\"357\" height=\"395\"><\/figure>\n<\/div>\n<p> Puede utilizar los siguientes pasos:<\/p>\n<ol type=\"1\">\n<li> Primero, comience a escribir la funci\u00f3n CONTAR.SI en la celda B1 (Ingrese =CONTAR.SI).<\/li>\n<li> Despu\u00e9s de eso, en el primer argumento de la funci\u00f3n, consulte la columna A, tambi\u00e9n puede consultar A1:A101 \u00fanicamente.<\/li>\n<li> Ahora escriba una coma e ingrese el segundo argumento.<\/li>\n<li> A partir de ah\u00ed debe especificar el argumento de los criterios. Entonces, escriba &lt;=45 entre comillas dobles.<\/li>\n<li> Al final, escriba el par\u00e9ntesis de cierre y presione Entrar. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67116\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-countif-fonction-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-countif-usada\" width=\"413\" height=\"344\"><\/figure>\n<\/div>\n<p> Y una vez que presionas Enter, te devuelve la cantidad de celdas con valores menores o iguales a 46. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67117\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-nombre-de-valeurs-selon-les-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"numero-de-valores-segun-los-criterios\" width=\"462\" height=\"323\"><\/figure>\n<\/div>\n<p> Tambi\u00e9n puede especificar una celda que contenga el valor del criterio. En el siguiente ejemplo, tiene un valor en la celda B1 que desea usar como criterio y luego hace referencia a la celda en la funci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67118\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-countif-avec-criteres.png\" sizes=\"auto, \" srcset=\"\" alt=\"cuenta-con-criterios\" width=\"472\" height=\"287\"><\/figure>\n<\/div>\n<p> Ahora, si ves, tenemos la f\u00f3rmula en la celda B4. Ahora bien, en esta f\u00f3rmula nos hemos referido al rango A1:A101.<\/p>\n<p> Y en el segundo argumento, donde necesitamos especificar los criterios, ingresamos el operador mayor e igual usando comillas dobles.<\/p>\n<p> Despu\u00e9s de eso, usamos un signo y nos referimos a la celda B1.<\/p>\n<p> De esta manera, si deseas cambiar el criterio, no necesitas cambiar el valor de la f\u00f3rmula en s\u00ed, puedes cambiarlo desde la celda B1.<\/p>\n<h2 class=\"wp-block-heading\"> Comidas para llevar<\/h2>\n<ol type=\"1\">\n<li> Cuando usas &lt;=, Excel lo trata como menor que e igual a. Entonces, si usas &lt;= 45 significa todos los valores menores que 45. Pero si usas solo &lt; significa que solo te refieres a valores menores que, por ejemplo &lt;45 significa valores menores que 45.<\/li>\n<li> Tambi\u00e9n puede crear m\u00faltiples criterios usando una funci\u00f3n CONTAR.SI y aparte de esto puede usar CONTAR.SI O en Excel para crear l\u00f3gica o mientras cuenta valores menores que. <\/li>\n<\/ol>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/compter-si-moins-de-2.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-entre-dos-numeros\/\">Contar entre dos n\u00fameros (CONTAR.SI) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-celdas-no-iguales-a\/\">Contar celdas distintas a en Excel (CONTAR.SI)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contar-celdas-que-no-esten-en-blanco\/\">Contar celdas que no est\u00e1n vac\u00edas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cuenta-mayor-que-cero\/\">Cuente mayor que 0 (CONTAR.SI) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/conteos-contables-o-logicos\/\">O L\u00f3gica en CONTAR.SI\/CONTAR.SI en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, si desea contar celdas que tienen un valor menor o menor que un valor particular, debe usar la funci\u00f3n CONTAR.SI. Con esta funci\u00f3n, puede especificar un rango de valores para contar y luego una cantidad de criterios para contar las celdas siguientes. En este tutorial de f\u00f3rmulas, veremos algunos ejemplos para entenderla. CONTAR.SI [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-81","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo contar celdas menores que un valor particular?<\/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:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo contar celdas menores que un valor particular?\" \/>\n<meta property=\"og:description\" content=\"En Excel, si desea contar celdas que tienen un valor menor o menor que un valor particular, debe usar la funci\u00f3n CONTAR.SI. Con esta funci\u00f3n, puede especificar un rango de valores para contar y luego una cantidad de criterios para contar las celdas siguientes. En este tutorial de f\u00f3rmulas, veremos algunos ejemplos para entenderla. CONTAR.SI [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\",\"name\":\"\u00bfc\u00f3mo contar celdas menores que un valor particular?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"datePublished\":\"2023-11-17T07:39:08+00:00\",\"dateModified\":\"2023-12-25T10:24:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo contar celdas menores que un valor particular?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo contar celdas menores que un valor particular?","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:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo contar celdas menores que un valor particular?","og_description":"En Excel, si desea contar celdas que tienen un valor menor o menor que un valor particular, debe usar la funci\u00f3n CONTAR.SI. Con esta funci\u00f3n, puede especificar un rango de valores para contar y luego una cantidad de criterios para contar las celdas siguientes. En este tutorial de f\u00f3rmulas, veremos algunos ejemplos para entenderla. CONTAR.SI [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/","url":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/","name":"\u00bfc\u00f3mo contar celdas menores que un valor particular?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","datePublished":"2023-11-17T07:39:08+00:00","dateModified":"2023-12-25T10:24:37+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-liste-de-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/contar-si-es-menor-que\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo contar celdas menores que un valor particular?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=81"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/81\/revisions"}],"predecessor-version":[{"id":941,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/81\/revisions\/941"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}