{"id":13823,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/averagea\/"},"modified":"2021-02-26T08:42:17","modified_gmt":"2021-02-26T08:42:17","slug":"averagea","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/averagea\/","title":{"rendered":"AVERAGEA"},"content":{"rendered":"

Descripci\u00f3n y Sintaxis de la Funci\u00f3n<\/h2>\n

La funci\u00f3n AVERAGEA en Excel y Google Sheets permite calcular el promedio de un conjunto de valores, incluyendo n\u00fameros, texto y valores l\u00f3gicos dentro de un rango especificado. En el caso de los valores de texto y los valores l\u00f3gicos, estos se contabilizan de manera espec\u00edfica: el texto y el valor l\u00f3gico FALSE se consideran como 0, mientras que el valor l\u00f3gico TRUE se considera como 1. Esta funci\u00f3n se diferencia de AVERAGE, que excluye los valores no num\u00e9ricos con la excepci\u00f3n del cero.<\/p>\n

Sintaxis en Excel y Google Sheets:<\/p>\n

=AVERAGEA(valor1, [valor2], ...)<\/code><\/pre>\n
Los argumentos valor1<\/i>, valor2<\/i>, etc., pueden ser n\u00fameros, referencias a celdas o rangos.<\/p>\n
    \n
  • valor1<\/strong>: Obligatorio. Primer n\u00famero, celda o rango a incluir en el promedio.<\/li>\n
  • valor2, …<\/strong>: Opcional. N\u00fameros, celdas o rangos adicionales a considerar en el c\u00e1lculo del promedio.<\/li>\n<\/ul>\n
    Ejemplos de Uso<\/h2>\n
    Consideremos la siguiente tabla como ejemplo:<\/p>\n\n\n\n\n\n
    Producto<\/th>\nPrecio<\/th>\nVendido<\/th>\n<\/tr>\n
    Zapatos<\/td>\n120<\/td>\nTRUE<\/td>\n<\/tr>\n
    Camisa<\/td>\n80<\/td>\nFALSE<\/td>\n<\/tr>\n
    Pantalones<\/td>\n90<\/td>\nTRUE<\/td>\n<\/tr>\n<\/table>\n
    Para calcular el promedio de los precios y los indicadores de ventas, se utilizar\u00eda:<\/p>\n
    =AVERAGEA(B2:B4, C2:C4)<\/code><\/pre>\n
    En este caso, TRUE se considera como 1 y FALSE como 0. Se computar\u00eda el promedio de los valores (120, 80, 90, 1, 0, 1), resultando en 48.67.<\/p>\n
    Casos Pr\u00e1cticos<\/h2>\n
    Calculando Promedios Mixtos<\/h2>\n
    Supongamos que es necesario evaluar el rendimiento de un grupo de estudiantes incorporando tanto sus calificaciones como su asistencia, indicada con los valores TRUE (asisti\u00f3) o FALSE (no asisti\u00f3).<\/p>\n
    Utilizando AVERAGEA, puedes contar la asistencia como parte de la evaluaci\u00f3n, asignando un punto a quienes asistieron y cero a quienes no:<\/p>\n
    =AVERAGEA(A2:A5, B2:B5)<\/code><\/pre>\n
    Se calcular\u00eda el promedio de (75, 85, 90, 65, 1, 0, 1, 1), resultando en 39.75.<\/p>\n
    Evaluaci\u00f3n de Datos con Valores Verdadero\/Falso<\/h2>\n
    En el contexto corporativo, puede ser \u00fatil evaluar la efectividad de campa\u00f1as publicitarias clasificadas como exitosas (TRUE) o no exitosas (FALSE), junto con sus costos asociados.<\/p>\n
    Para obtener un promedio general del costo y \u00e9xito de las campa\u00f1as, la f\u00f3rmula recomendada ser\u00eda:<\/p>\n
    =AVERAGEA(C2:C4, D2:D4)<\/code><\/pre>\n
    Esto ofrece un promedio de los valores (200, 150, 180, 1, 0, 1) resultando en 88.67, brindando una visi\u00f3n integral sobre la inversi\u00f3n y resultados de las campa\u00f1as.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Devuelve el promedio de sus argumentos, incluidos n\u00fameros, texto y valores l\u00f3gicos<\/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-13823","post","type-post","status-publish","format-standard","hentry","category-estadistica"],"acf":[],"yoast_head":"\nFunci\u00f3n AVERAGEA en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA 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\/averagea\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n AVERAGEA en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/averagea\/\" \/>\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:42: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 AVERAGEA 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\/averagea\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/averagea\/\",\"name\":\"Funci\u00f3n AVERAGEA 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:42:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/averagea\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/averagea\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/averagea\/#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\":\"AVERAGEA\"}]},{\"@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 AVERAGEA en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA 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\/averagea\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n AVERAGEA en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/averagea\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:42:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n AVERAGEA 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\/averagea\/","url":"https:\/\/functiontranslator.com\/es\/averagea\/","name":"Funci\u00f3n AVERAGEA 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:42:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n AVERAGEA de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/averagea\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/averagea\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/averagea\/#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":"AVERAGEA"}]},{"@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\/13823","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=13823"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13823\/revisions"}],"predecessor-version":[{"id":29890,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13823\/revisions\/29890"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}