{"id":13825,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/averageifs-function\/"},"modified":"2021-03-01T16:38:31","modified_gmt":"2021-03-01T16:38:31","slug":"averageifs","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/averageifs\/","title":{"rendered":"AVERAGEIFS"},"content":{"rendered":"

La funci\u00f3n AVERAGEIFS en Excel y Google Sheets permite calcular el promedio de un conjunto de datos bas\u00e1ndose en m\u00faltiples criterios. Esta herramienta es extremadamente \u00fatil cuando es necesario obtener promedios de datos espec\u00edficos dentro de una selecci\u00f3n m\u00e1s amplia y donde cada criterio es crucial para determinar qu\u00e9 datos incluir en el c\u00e1lculo del promedio.<\/p>\n

Sintaxis y ejemplos b\u00e1sicos<\/h2>\n

La sintaxis de la funci\u00f3n AVERAGEIFS se estructura de la siguiente manera:<\/p>\n

AVERAGEIFS(rango_promedio, criterio_rango1, criterio1, [criterio_rango2, criterio2], ...)<\/code><\/pre>\n
    \n
  • rango_promedio<\/strong>: El grupo de celdas cuyo promedio se desea calcular.<\/li>\n
  • criterio_rango1<\/strong>: El rango de celdas que se evaluar\u00e1 seg\u00fan el primer criterio.<\/li>\n
  • criterio1<\/strong>: El criterio que deben cumplir las celdas en el criterio_rango1 para ser incluidas en el c\u00e1lculo del promedio.<\/li>\n
  • criterio_rango2, criterio2, …<\/strong>: Rangos y criterios adicionales que pueden agregarse seg\u00fan sea necesario.<\/li>\n<\/ul>\n
    Ejemplo de c\u00f3mo utilizar la funci\u00f3n AVERAGEIFS:<\/p>\n
    =AVERAGEIFS(A2:A10, B2:B10, \">20\", C2:C10, \"<30\")<\/code><\/pre>\n
    En este caso, el promedio se calcula sobre el rango de A2:A10, pero solo incluir\u00e1 aquellas celdas cuyos valores en los rangos de B2:B10 y C2:C10 sean mayores a 20 y menores a 30, respectivamente.<\/p>\n
    Aplicaciones pr\u00e1cticas de la funci\u00f3n<\/h2>\n
    Calculando promedios condicionales en datos de ventas<\/h2>\n
    Imagina que tienes una lista de ventas de distintos productos en varias ciudades y quieres calcular el promedio de ventas de un producto espec\u00edfico en ciudades con m\u00e1s de 100,000 habitantes. Los datos se presentan de la siguiente manera:<\/p>\n\n\n\n\n\n
    Producto<\/th>\nVentas<\/th>\nCiudad<\/th>\nPoblaci\u00f3n<\/th>\n<\/tr>\n
    Producto A<\/td>\n150<\/td>\nCiudad X<\/td>\n120000<\/td>\n<\/tr>\n
    Producto B<\/td>\n200<\/td>\nCiudad Y<\/td>\n50000<\/td>\n<\/tr>\n
    Producto A<\/td>\n300<\/td>\nCiudad Z<\/td>\n130000<\/td>\n<\/tr>\n<\/table>\n
    Para calcular el promedio de ventas de \u00abProducto A\u00bb en ciudades con poblaci\u00f3n mayor a 100,000, utilizar\u00edas:<\/p>\n
    =AVERAGEIFS(B2:B4, A2:A4, \"Producto A\", D2:D4, \">100000\")<\/code><\/pre>\n
    El resultado ser\u00eda el promedio de las ventas de Producto A en ciudades que exceden los 100,000 habitantes.<\/p>\n
    An\u00e1lisis de promedios de rendimiento estudiantil<\/h2>\n
    Considera una tabla con las calificaciones de estudiantes en distintas asignaturas y deseas conocer el promedio de calificaciones en matem\u00e1ticas de aquellos estudiantes que han obtenido m\u00e1s de 85 en ciencias. Los datos son los siguientes:<\/p>\n\n\n\n\n\n
    Estudiante<\/th>\nMatem\u00e1ticas<\/th>\nCiencias<\/th>\nLiteratura<\/th>\n<\/tr>\n
    Juan<\/td>\n90<\/td>\n87<\/td>\n82<\/td>\n<\/tr>\n
    Maria<\/td>\n85<\/td>\n80<\/td>\n90<\/td>\n<\/tr>\n
    Luis<\/td>\n88<\/td>\n90<\/td>\n85<\/td>\n<\/tr>\n<\/table>\n
    Para calcular el promedio de matem\u00e1ticas de los estudiantes con m\u00e1s de 85 en ciencias, usar\u00edas:<\/p>\n
    =AVERAGEIFS(B2:B4, C2:C4, \">85\")<\/code><\/pre>\n
    Esto resultar\u00eda en el promedio de las calificaciones de matem\u00e1ticas de Juan y Luis, quienes cumplen con el criterio establecido para ciencias.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el promedio (media aritm\u00e9tica) de todas las celdas que cumplen m\u00faltiples criterios<\/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-13825","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n AVERAGEIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS 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\/averageifs\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n AVERAGEIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/averageifs\/\" \/>\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-03-01T16:38:31+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 AVERAGEIFS 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\/averageifs\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/averageifs\/\",\"name\":\"Funci\u00f3n AVERAGEIFS 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-03-01T16:38:31+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/averageifs\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/averageifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/averageifs\/#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\":\"AVERAGEIFS\"}]},{\"@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 AVERAGEIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS 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\/averageifs\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n AVERAGEIFS en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/averageifs\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-03-01T16:38:31+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n AVERAGEIFS 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\/averageifs\/","url":"https:\/\/functiontranslator.com\/es\/averageifs\/","name":"Funci\u00f3n AVERAGEIFS 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-03-01T16:38:31+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEIFS de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/averageifs\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/averageifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/averageifs\/#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":"AVERAGEIFS"}]},{"@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\/13825","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=13825"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13825\/revisions"}],"predecessor-version":[{"id":32536,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13825\/revisions\/32536"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}