{"id":13918,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/bdcontar\/"},"modified":"2021-02-26T08:45:13","modified_gmt":"2021-02-26T08:45:13","slug":"dcount","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/dcount\/","title":{"rendered":"BDCONTAR"},"content":{"rendered":"

La funci\u00f3n BDCONTAR en Microsoft Excel y Google Sheets es una herramienta \u00fatil para contar el n\u00famero de celdas que satisfacen ciertas condiciones dentro de un rango que act\u00faa como base de datos. A continuaci\u00f3n, se detalla su sintaxis y se muestra c\u00f3mo utilizarla eficazmente en diversos contextos.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis de la funci\u00f3n BDCONTAR en Excel es:<\/p>\n

=BDCONTAR(base_de_datos; campo; criterios)<\/code><\/pre>\n
    \n
  • base_de_datos<\/strong>: El rango de celdas que se utiliza como base de datos.<\/li>\n
  • campo<\/strong>: El nombre de la columna de la base de datos que deseamos contar. Este puede especificarse mediante un n\u00famero de \u00edndice (comenzando desde 1, de acuerdo al orden de las columnas en los datos), o como el nombre de la columna entre comillas.<\/li>\n
  • criterios<\/strong>: El rango de celdas que contiene las condiciones que deben cumplirse.<\/li>\n<\/ul>\n
    Ejemplo en Excel:<\/p>\n\n\n\n\n\n
    Nombre<\/td>\nEdad<\/td>\nSalario<\/td>\n<\/tr>\n
    Juan<\/td>\n25<\/td>\n4000<\/td>\n<\/tr>\n
    Sof\u00eda<\/td>\n30<\/td>\n4500<\/td>\n<\/tr>\n
    Miguel<\/td>\n22<\/td>\n3500<\/td>\n<\/tr>\n<\/table>\n
    Si deseamos contar cu\u00e1ntas personas tienen m\u00e1s de 24 a\u00f1os, establecer\u00edamos un rango de criterios as\u00ed:<\/p>\n\n\n\n
    Edad<\/td>\n<\/tr>\n
    >24<\/td>\n<\/tr>\n<\/table>\n
    Luego, aplicar\u00edamos la f\u00f3rmula:<\/p>\n
    =BDCONTAR(A1:C4; \"Edad\"; A6:B7)<\/code><\/pre>\n
    Esto devuelve el valor 2, indicando que hay dos personas mayores de 24 a\u00f1os.<\/p>\n
    Casos Pr\u00e1cticos<\/h2>\n
    1. Contando empleados en distintos rangos de salario<\/h2>\n
    Supongamos que una empresa desea evaluar cu\u00e1ntos de sus empleados ganan entre 3000 y 5000 como parte de una decisi\u00f3n de reestructuraci\u00f3n salarial. Con BDCONTAR, este n\u00famero se puede obtener f\u00e1cilmente.<\/p>\n
    Rango de criterios:<\/p>\n\n\n\n\n
    Salario<\/td>\n<\/tr>\n
    >=3000<\/td>\n<\/tr>\n
    <=5000<\/td>\n<\/tr>\n<\/table>\n
    =BDCONTAR(A1:C4; \"Salario\"; A6:B8)<\/code><\/pre>\n
    Este ejemplo contar\u00e1 todos los empleados cuyo salario est\u00e1 entre 3000 y 5000, inclusive.<\/p>\n
    2. Evaluaci\u00f3n de edad para programas de formaci\u00f3n<\/h2>\n
    Otra aplicaci\u00f3n frecuente de BDCONTAR es determinar el n\u00famero de empleados que se encuentran dentro de un rango de edad espec\u00edfico para programas de capacitaci\u00f3n dirigidos a ciertas edades.<\/p>\n
    Rango de criterios:<\/p>\n\n\n\n\n
    Edad<\/td>\n<\/tr>\n
    >=20<\/td>\n<\/tr>\n
    <=30<\/td>\n<\/tr>\n<\/table>\n
    =BDCONTAR(A1:C4; \"Edad\"; A9:B11)<\/code><\/pre>\n
    Este m\u00e9todo permite a la compa\u00f1\u00eda identificar cu\u00e1ntos trabajadores son aptos para un programa de entrenamiento destinado a empleados de 20 a 30 a\u00f1os.<\/p>\n
    En resumen, la funci\u00f3n BDCONTAR es extremadamente \u00fatil para realizar conteos condicionales de manera eficiente en grandes vol\u00famenes de datos, facilitando la toma de decisiones basadas en criterios espec\u00edficos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Cuenta el n\u00famero de celdas que contienen n\u00fameros en una base de datos<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[547],"tags":[],"class_list":["post-13918","post","type-post","status-publish","format-standard","hentry","category-base-de-datos"],"acf":[],"yoast_head":"\nFunci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/dcount\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/dcount\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:45:13+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dcount\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/dcount\/\",\"name\":\"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:45:13+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/dcount\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/dcount\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/dcount\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de datos\",\"item\":\"https:\/\/functiontranslator.com\/es\/base-de-datos\/\"},{\"@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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos 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\/es\/dcount\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/dcount\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:13+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/dcount\/","url":"https:\/\/functiontranslator.com\/es\/dcount\/","name":"Funci\u00f3n DCOUNT (BDCONTAR) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:45:13+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DCOUNT (BDCONTAR) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/dcount\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/dcount\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/dcount\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Base de datos","item":"https:\/\/functiontranslator.com\/es\/base-de-datos\/"},{"@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":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13918"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13918\/revisions"}],"predecessor-version":[{"id":29981,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13918\/revisions\/29981"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}