{"id":10840,"date":"2025-07-15T13:34:50","date_gmt":"2025-07-15T13:34:50","guid":{"rendered":"https:\/\/functiontranslator.com\/bdcontar\/"},"modified":"2021-02-25T17:17:23","modified_gmt":"2021-02-25T17:17:23","slug":"dcount","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/","title":{"rendered":"BDCONTAR"},"content":{"rendered":"

A fun\u00e7\u00e3o DCOUNT, conhecida como BDCONTAR em portugu\u00eas, \u00e9 ferramenta extremamente \u00fatil tanto no Microsoft Excel quanto no Google Planilhas para contar c\u00e9lulas que cont\u00eam n\u00fameros em um banco de dados ou intervalo que corresponda a condi\u00e7\u00f5es especificadas. Esta fun\u00e7\u00e3o \u00e9 frequentemente utilizada para an\u00e1lise de dados detalhada onde a contagem condicional \u00e9 necess\u00e1ria.<\/p>\n

Compreendendo o Sintaxe<\/h2>\n

O sintaxe de BDCONTAR \u00e9:<\/p>\n

=BDCONTAR(database; field; criteria)<\/code><\/pre>\n
Onde:<\/p>\n
    \n
  • database<\/strong>: o intervalo de c\u00e9lulas que faz seu banco de dados, incluindo os r\u00f3tulos de colunas nos dados.<\/li>\n
  • field<\/strong>: indica qual coluna ser\u00e1 usada para a contagem. Pode ser especificada tanto pelo nome da coluna entre aspas (“Nome”) como pelo n\u00famero da coluna (1 para a primeira coluna do intervalo, 2 para a segunda, e assim por diante).<\/li>\n
  • criteria<\/strong>: o intervalo de c\u00e9lulas que cont\u00e9m as condi\u00e7\u00f5es que voc\u00ea especificou. A primeira linha desse intervalo deve incluir r\u00f3tulos de coluna que correspondam \u00e0queles no intervalo de dados.<\/li>\n<\/ul>\n
    Exemplo b\u00e1sico:<\/p>\n
    =BDCONTAR(A1:C10; \"Idade\"; F1:F2)<\/code><\/pre>\n
    Este exemplo conta quantas entradas na coluna “Idade” do intervalo A1:C10 atendem aos crit\u00e9rios especificados no intervalo F1:F2.<\/p>\n
    Situa\u00e7\u00f5es Pr\u00e1ticas de Uso<\/h2>\n
    An\u00e1lise de Dados Demogr\u00e1ficos<\/h2>\n
    Suponha que voc\u00ea tenha um banco de dados escolar e precise contar quantos estudantes t\u00eam mais de 12 anos.<\/p>\n
    Dados:<\/p>\n
      \n
    • A1: Nome<\/li>\n
    • B1: Idade<\/li>\n
    • A2:A11: Ana, Jo\u00e3o, Maria, Jos\u00e9, etc.<\/li>\n
    • B2:B11: 10, 13, 12, 14, etc.<\/li>\n<\/ul>\n
      Crit\u00e9rios:<\/p>\n
        \n
      • E1: Idade<\/li>\n
      • E2: >12<\/li>\n<\/ul>\n
        F\u00f3rmula:<\/p>\n
        =BDCONTAR(A1:B11; \"Idade\"; E1:E2)<\/code><\/pre>\n
        Este exemplo retornar\u00e1 o n\u00famero de estudantes com idade superior a 12 anos.<\/p>\n
        An\u00e1lise Financeira<\/h2>\n
        Vamos considerar que voc\u00ea seja um analista financeiro que deseja contar quantas transa\u00e7\u00f5es superaram um valor espec\u00edfico no m\u00eas de janeiro.<\/p>\n
        Dados:<\/p>\n
          \n
        • A1: Data<\/li>\n
        • B1: Valor<\/li>\n
        • A2:A31: 01\/01\/2023, 02\/01\/2023, …, 31\/01\/2023<\/li>\n
        • B2:B31: 200, 300, 450, 100, etc.<\/li>\n<\/ul>\n
          Crit\u00e9rios:<\/p>\n
            \n
          • D1: Valor<\/li>\n
          • D2: >400<\/li>\n<\/ul>\n
            F\u00f3rmula:<\/p>\n
            =BDCONTAR(A1:B31; \"Valor\"; D1:D2)<\/code><\/pre>\n
            Essa f\u00f3rmula calcular\u00e1 quantas transa\u00e7\u00f5es excederam o valor de 400 no intervalo dado.<\/p>\n
            Estes s\u00e3o apenas alguns exemplos do poder da fun\u00e7\u00e3o BDCONTAR para lidar com grandes volumes de dados e realizar an\u00e1lises complexas de forma eficiente e eficaz no Excel e nas Google Planilhas.<\/p>\n","protected":false},"excerpt":{"rendered":"
            Conta as c\u00e9lulas que cont\u00eam n\u00fameros numa base de dados<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[449],"tags":[],"class_list":["post-10840","post","type-post","status-publish","format-standard","hentry","category-base-de-dados"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:17:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/\",\"name\":\"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:50+00:00\",\"dateModified\":\"2021-02-25T17:17:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/dcount\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de dados\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/base-de-dados\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BDCONTAR\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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:\/\/functiontranslator.com\/pt-pt\/dcount\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:50+00:00","article_modified_time":"2021-02-25T17:17:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/","url":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/","name":"Fun\u00e7\u00e3o DCOUNT (BDCONTAR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:50+00:00","dateModified":"2021-02-25T17:17:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o DCOUNT (BDCONTAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/dcount\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/dcount\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Base de dados","item":"https:\/\/functiontranslator.com\/pt-pt\/base-de-dados\/"},{"@type":"ListItem","position":3,"name":"BDCONTAR"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=10840"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10840\/revisions"}],"predecessor-version":[{"id":25669,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/10840\/revisions\/25669"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=10840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=10840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=10840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}