{"id":80,"date":"2023-11-17T07:39:08","date_gmt":"2023-11-17T07:39:08","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/"},"modified":"2023-12-06T11:35:35","modified_gmt":"2023-12-06T11:35:35","slug":"conte-se-for-menor-que","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/","title":{"rendered":"Como contar c\u00e9lulas menores que um valor espec\u00edfico?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-518239113\"><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><div class=\"excel-before-content\" id=\"excel-47226079\"><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>No Excel, se voc\u00ea deseja contar c\u00e9lulas que possuem um valor menor ou inferior a um determinado valor, voc\u00ea precisa usar a fun\u00e7\u00e3o CONT.SE. Com esta fun\u00e7\u00e3o, voc\u00ea pode especificar um intervalo de valores para contar e, em seguida, uma s\u00e9rie de crit\u00e9rios para contar as c\u00e9lulas abaixo.<\/p><p> Neste tutorial de f\u00f3rmula, veremos alguns exemplos para entend\u00ea-la.<\/p><h2 class=\"wp-block-heading\"> COUNTIF para contar menos c\u00e9lulas<\/h2><p> No exemplo a seguir, temos uma lista de valores na coluna (uma lista de 1000 n\u00fameros). Agora voc\u00ea precisa contar as c\u00e9lulas menores que 45. Como eu disse, voc\u00ea precisa usar CONT.SE, escreveremos esta f\u00f3rmula na c\u00e9lula B1. <\/p><div class=\"wp-block-image\"><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><\/div><p> Voc\u00ea pode usar as seguintes etapas:<\/p><ol type=\"1\"><li> Primeiro, comece a digitar a fun\u00e7\u00e3o CONT.SE na c\u00e9lula B1 (digite =CONT.SE).<\/li><li> Depois disso, no primeiro argumento da fun\u00e7\u00e3o, consulte a coluna A, voc\u00ea tamb\u00e9m pode consultar apenas A1:A101.<\/li><li> Agora digite uma v\u00edrgula e insira o segundo argumento.<\/li><li> A partir da\u00ed voc\u00ea precisa especificar o argumento para os crit\u00e9rios. Ent\u00e3o, digite &lt;=45 com aspas duplas.<\/li><li> No final, digite os par\u00eanteses de fechamento e pressione Enter. <\/li><\/ol><div class=\"wp-block-image\"><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=\"fun\u00e7\u00e3o countif-usada\" width=\"413\" height=\"344\"><\/figure><\/div><p> E ao pressionar Enter, ele retorna o n\u00famero de c\u00e9lulas com valores menores ou iguais a 46. <\/p><div class=\"wp-block-image\"><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=\"n\u00famero de valores de acordo com os crit\u00e9rios\" width=\"462\" height=\"323\"><\/figure><\/div><p> Voc\u00ea tamb\u00e9m pode especificar uma c\u00e9lula contendo o valor do crit\u00e9rio. No exemplo a seguir, voc\u00ea tem um valor na c\u00e9lula B1 que deseja usar como crit\u00e9rio e, em seguida, faz refer\u00eancia \u00e0 c\u00e9lula na fun\u00e7\u00e3o. <\/p><div class=\"wp-block-image\"><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=\"conta com crit\u00e9rios\" width=\"472\" height=\"287\"><\/figure><\/div><p> Agora, se voc\u00ea ver, temos a f\u00f3rmula na c\u00e9lula B4. Agora nesta f\u00f3rmula nos referimos ao intervalo A1:A101.<\/p><p> E no segundo argumento, onde precisamos especificar os crit\u00e9rios, inserimos o operador maior e igual usando aspas duplas.<\/p><p> Depois disso, usamos um E comercial e nos referimos \u00e0 c\u00e9lula B1.<\/p><p> Dessa forma, se quiser alterar os crit\u00e9rios, n\u00e3o \u00e9 necess\u00e1rio alterar o valor da f\u00f3rmula em si, voc\u00ea pode alter\u00e1-lo a partir da c\u00e9lula B1.<\/p><h2 class=\"wp-block-heading\"> Aprendizado<\/h2><ol type=\"1\"><li> Quando voc\u00ea usa &lt;=, o Excel o trata como menor e igual a. Ent\u00e3o se voc\u00ea usar &lt;= 45 significa todos os valores menores que 45. Mas se voc\u00ea usar apenas &lt; significa que voc\u00ea se refere apenas a valores menores que, por exemplo &lt;45 significa valores menores que 45 .<\/li><li> Voc\u00ea tamb\u00e9m pode criar v\u00e1rios crit\u00e9rios usando uma fun\u00e7\u00e3o COUNTIFS e, al\u00e9m disso, voc\u00ea pode usar CONT.SE OR no Excel para criar l\u00f3gica ou enquanto conta valores menores que. <\/li><\/ol><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtenha o arquivo Excel<\/h2> <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\">Download<\/a><\/div><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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/contar-entre-dois-numeros\/\">Conte entre dois n\u00fameros (COUNTIFS) no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/contar-celulas-diferentes-de\/\">Contar c\u00e9lulas diferentes do Excel (COUNTIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/contar-celulas-nao-vazias\/\">Contar c\u00e9lulas que n\u00e3o est\u00e3o vazias no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/conta-maior-que-zero\/\">Contagem maior que 0 (CONT.SE) no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/contantes-countif-ou-logico\/\">L\u00f3gica OR em COUNTIF\/COUNIFS no Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","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-80","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>Como contar c\u00e9lulas menores que um valor espec\u00edfico?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis\" \/>\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\/pt\/conte-se-for-menor-que\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como contar c\u00e9lulas menores que um valor espec\u00edfico?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:35+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=\"Tempo estimado de leitura\" \/>\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\/pt\/conte-se-for-menor-que\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/\",\"name\":\"Como contar c\u00e9lulas menores que um valor espec\u00edfico?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-se-for-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-06T11:35:35+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/conte-se-for-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\/pt\/conte-se-for-menor-que\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como contar c\u00e9lulas menores que um valor espec\u00edfico?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como contar c\u00e9lulas menores que um valor espec\u00edfico?","description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis","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\/pt\/conte-se-for-menor-que\/","og_locale":"pt_PT","og_type":"article","og_title":"Como contar c\u00e9lulas menores que um valor espec\u00edfico?","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis","og_url":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:35+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":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/","url":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/","name":"Como contar c\u00e9lulas menores que um valor espec\u00edfico?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-se-for-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-06T11:35:35+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 diferentes maneiras de contar caracteres espec\u00edficos no Excel usando f\u00f3rmulas f\u00e1ceis","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/conte-se-for-menor-que\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/conte-se-for-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\/pt\/conte-se-for-menor-que\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como contar c\u00e9lulas menores que um valor espec\u00edfico?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/80\/revisions"}],"predecessor-version":[{"id":920,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/80\/revisions\/920"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}