{"id":13886,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/contar-si\/"},"modified":"2021-02-26T08:44:17","modified_gmt":"2021-02-26T08:44:17","slug":"countif","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/countif\/","title":{"rendered":"CONTAR.SI"},"content":{"rendered":"

Introducci\u00f3n a la Funci\u00f3n CONTAR.SI<\/h2>\n

La funci\u00f3n CONTAR.SI, disponible tanto en Microsoft Excel como en Google Sheets, es fundamental para contar el n\u00famero de celdas que satisfacen un criterio espec\u00edfico dentro de un rango establecido. Esta funci\u00f3n es muy \u00fatil para realizar an\u00e1lisis r\u00e1pidos y efectivos en grandes conjuntos de datos, lo que facilita la toma de decisiones informadas.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis b\u00e1sica de la funci\u00f3n CONTAR.SI es la siguiente:<\/p>\n

CONTAR.SI(rango, criterio)<\/code><\/pre>\n
    \n
  • rango<\/strong>: Conjunto de celdas que se eval\u00faan seg\u00fan el criterio.<\/li>\n
  • criterio<\/strong>: Condici\u00f3n que deben cumplir las celdas para ser contadas. Este puede ser un n\u00famero, una expresi\u00f3n o un texto que defina dicha condici\u00f3n.<\/li>\n<\/ul>\n
    Ejemplo de uso en Excel y Google Sheets:<\/p>\n
    =CONTAR.SI(A1:A10, \"Manzanas\")<\/code><\/pre>\n
    Este ejemplo cuenta cu\u00e1ntas celdas en el rango de A1 a A10 contienen la palabra \u00abManzanas\u00bb.<\/p>\n
    Primer Escenario Pr\u00e1ctico: Conteo de Valores Espec\u00edficos<\/h2>\n
    Supongamos que tienes una lista de distintas frutas y deseas saber cu\u00e1ntas manzanas hay en ella.<\/p>\n\n\n\n\n\n\n
    Celda<\/th>\nValor<\/th>\n<\/tr>\n
    A1<\/td>\nManzanas<\/td>\n<\/tr>\n
    A2<\/td>\nPl\u00e1tanos<\/td>\n<\/tr>\n
    A3<\/td>\nManzanas<\/td>\n<\/tr>\n
    A4<\/td>\nCerezas<\/td>\n<\/tr>\n<\/table>\n
    Para contar cu\u00e1ntas manzanas hay, puedes utilizar la f\u00f3rmula:<\/p>\n
    =CONTAR.SI(A1:A4, \"Manzanas\")<\/code><\/pre>\n
    El resultado de esta f\u00f3rmula ser\u00e1 2, ya que hay dos celdas que contienen la palabra \u00abManzanas\u00bb.<\/p>\n
    Segundo Escenario Pr\u00e1ctico: Uso de Criterios Num\u00e9ricos<\/h2>\n
    Imagine que tienes una serie de datos que representan las edades de un grupo de personas y quieres saber cu\u00e1ntas de ellas tienen m\u00e1s de 18 a\u00f1os.<\/p>\n\n\n\n\n\n\n
    Celda<\/th>\nEdad<\/th>\n<\/tr>\n
    B1<\/td>\n22<\/td>\n<\/tr>\n
    B2<\/td>\n17<\/td>\n<\/tr>\n
    B3<\/td>\n34<\/td>\n<\/tr>\n
    B4<\/td>\n13<\/td>\n<\/tr>\n<\/table>\n
    Para determinar cu\u00e1ntas personas son mayores de 18 a\u00f1os, puedes usar:<\/p>\n
    =CONTAR.SI(B1:B4, \">18\")<\/code><\/pre>\n
    Esta f\u00f3rmula devolver\u00e1 2, indicando que hay dos personas que superan los 18 a\u00f1os de edad.<\/p>\n
    Conclusi\u00f3n<\/h2>\n
    La funci\u00f3n CONTAR.SI es una herramienta poderosa y vers\u00e1til en Excel y Google Sheets que simplifica la tarea de analizar datos basados en condiciones espec\u00edficas. Desde el conteo de frecuencias de palabras hasta la aplicaci\u00f3n de filtros num\u00e9ricos, esta funci\u00f3n ofrece diversas aplicaciones pr\u00e1cticas en el an\u00e1lisis de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Cuenta el n\u00famero de celdas, dentro del rango, que cumplen el criterio especificado<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[540],"tags":[],"class_list":["post-13886","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n COUNTIF (CONTAR.SI) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) 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\/countif\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n COUNTIF (CONTAR.SI) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/countif\/\" \/>\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:44:17+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 COUNTIF (CONTAR.SI) 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\/countif\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/countif\/\",\"name\":\"Funci\u00f3n COUNTIF (CONTAR.SI) 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:44:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/countif\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/countif\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/countif\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Estad\u00edstica\",\"item\":\"https:\/\/functiontranslator.com\/es\/estadistica\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"CONTAR.SI\"}]},{\"@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 COUNTIF (CONTAR.SI) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) 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\/countif\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n COUNTIF (CONTAR.SI) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/countif\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:44:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n COUNTIF (CONTAR.SI) 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\/countif\/","url":"https:\/\/functiontranslator.com\/es\/countif\/","name":"Funci\u00f3n COUNTIF (CONTAR.SI) 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:44:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n COUNTIF (CONTAR.SI) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/countif\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/countif\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/countif\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Estad\u00edstica","item":"https:\/\/functiontranslator.com\/es\/estadistica\/"},{"@type":"ListItem","position":3,"name":"CONTAR.SI"}]},{"@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\/13886","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=13886"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13886\/revisions"}],"predecessor-version":[{"id":29949,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13886\/revisions\/29949"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}