{"id":11932,"date":"2020-02-12T23:06:24","date_gmt":"2020-02-13T04:06:24","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=11932"},"modified":"2025-04-09T17:07:02","modified_gmt":"2025-04-09T22:07:02","slug":"promediar-y-sumar-letras-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/","title":{"rendered":"Promediar y sumar letras en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-aprende-facil-a-promediar-y-sumar-letras-en-excel\">Aprende F\u00e1cil a Promediar y Sumar Letras en Excel<\/h1>\n\n\n\n<p>\u00bfAlguna vez te has encontrado con la necesidad de promediar o sumar calificaciones representadas con letras en Excel? Aunque Excel trabaja principalmente con n\u00fameros, es posible realizar estos c\u00e1lculos convirtiendo las letras a valores num\u00e9ricos. En este post, te guiaremos paso a paso sobre c\u00f3mo lograr promediar y sumar letras en Excel, utilizando m\u00e9todos sencillos y f\u00f3rmulas efectivas, tal como se explica en este \u00fatil video de YouTube.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Promediar y Sumar letras en Excel (Funciones Anidadas) - Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/eR0C7G4wiWI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-2adce9\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-94e1c3 ultp-button-layout1\" href=\"https:\/\/www.mediafire.com\/file\/dcdxn87675ch67z\/Promedio_de_letras.zip\/file\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfPor Qu\u00e9 Promediar y Sumar Letras en Excel? Beneficios y Casos de Uso<\/h2>\n\n\n\n<p>Promediar y sumar letras en Excel puede ser \u00fatil en diversos escenarios, especialmente en el \u00e1mbito educativo donde las calificaciones suelen representarse con letras. Algunas de las ventajas incluyen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <strong>Flexibilidad en la Evaluaci\u00f3n<\/strong>: Permite trabajar con sistemas de calificaci\u00f3n alfab\u00e9ticos.<\/li>\n\n\n\n<li>\u2705 <strong>An\u00e1lisis de Rendimiento<\/strong>: Facilita el c\u00e1lculo del rendimiento general basado en calificaciones con letras.<\/li>\n\n\n\n<li>\u2705 <strong>Automatizaci\u00f3n de Procesos<\/strong>: Agiliza la obtenci\u00f3n de promedios sin necesidad de conversi\u00f3n manual.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Pasos para Promediar y Sumar Letras en Excel<\/h2>\n\n\n\n<p>A continuaci\u00f3n, te presentamos los pasos clave para realizar estos c\u00e1lculos en Excel, basados en la explicaci\u00f3n del video:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-configuracion-inicial-de-la-hoja-de-calculo-promediar-y-sumar-letras-en-excel\">1. Configuraci\u00f3n Inicial de la Hoja de C\u00e1lculo: Promediar y sumar letras en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"ecedf0\" data-has-transparency=\"true\" style=\"--dominant-color: #ecedf0;\" fetchpriority=\"high\" decoding=\"async\" width=\"373\" height=\"184\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-png.avif\" alt=\"Tabla simple en Excel con dos columnas, \" class=\"wp-image-25287 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-png.avif 373w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-300x148.avif 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/figure>\n\n\n\n<p>Se recomienda organizar tu informaci\u00f3n en dos hojas dentro del mismo libro de Excel:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Hoja de Datos<\/strong>: Contendr\u00e1 los nombres o identificadores y las calificaciones en letras.<\/li>\n\n\n\n<li><strong>Hoja de C\u00f3digos<\/strong>: Servir\u00e1 para comparar y convertir las letras en valores num\u00e9ricos y poder sumar en Excel. Por ejemplo: A=4, B=3, C=2, D=1, F=0.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-conversion-de-letras-a-numeros-usando-formulas-promediar-y-sumar-letras-en-excel\">2. Conversi\u00f3n de Letras a N\u00fameros Usando F\u00f3rmulas: Promediar y sumar letras en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"dce0e9\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"184\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-1024x184.avif\" alt=\"Hoja de c\u00e1lculo de Excel mostrando una f\u00f3rmula compleja utilizando la funci\u00f3n SI para asignar valores num\u00e9ricos a letras basadas en un promedio, junto con una tabla de referencia.\" class=\"wp-image-25289 has-transparency\" style=\"--dominant-color: #dce0e9; width:791px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-1024x184.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-300x54.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-768x138.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-1536x276.avif 1536w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-600x108.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-2-png.avif 1738w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>El video explica c\u00f3mo utilizar la funci\u00f3n anidada <code>SI<\/code> para convertir las calificaciones de letras a sus equivalentes num\u00e9ricos en la Hoja de Datos. Por ejemplo, si la calificaci\u00f3n se encuentra en la columna B, puedes usar una f\u00f3rmula como la siguiente en una columna adyacente (por ejemplo, la columna C):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI(B2=\"A\",4,SI(B2=\"B\",3,SI(B2=\"C\",2,SI(B2=\"D\",1,SI(B2=\"F\",0,\"\")\n<\/code><\/pre>\n\n\n\n<p>Esta f\u00f3rmula eval\u00faa la letra en la celda B2 y devuelve el n\u00famero correspondiente. Puedes extender esta f\u00f3rmula a las dem\u00e1s celdas de la columna C.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. C\u00e1lculo del Promedio de las Calificaciones Num\u00e9ricas<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"acbad2\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"106\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-1024x106.avif\" alt=\"\" class=\"wp-image-25291 has-transparency\" style=\"--dominant-color: #acbad2; width:773px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-1024x106.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-300x31.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-768x79.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-600x62.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-4-png.avif 1237w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Una vez que tengas las calificaciones convertidas a n\u00fameros, puedes usar la funci\u00f3n <code>PROMEDIO<\/code> para calcular el promedio de esas letras que has convertido. Por ejemplo, si las calificaciones num\u00e9ricas est\u00e1n en la columna C, puedes usar la siguiente f\u00f3rmula en la celda donde quieras mostrar el promedio:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=PROMEDIO(C2:C10)\n<\/code><\/pre>\n\n\n\n<p>Ajusta el rango de celdas (C2:C10) seg\u00fan tus datos.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Redondeo del Promedio (Opcional)<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"a8b6d0\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"100\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-1024x100.avif\" alt=\"\" class=\"wp-image-25292 has-transparency\" style=\"--dominant-color: #a8b6d0; width:821px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-1024x100.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-300x29.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-768x75.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-600x58.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-5-png.avif 1232w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Si deseas redondear el promedio a un n\u00famero entero, puedes utilizar la funci\u00f3n <code>REDONDEAR<\/code>. Por ejemplo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=REDONDEAR(PROMEDIO(C2:C10),0)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. Conversi\u00f3n del Promedio Num\u00e9rico de Vuelta a una Letra (Opcional)<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"a9b6d0\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"104\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-1024x104.avif\" alt=\"\" class=\"wp-image-25290 has-transparency\" style=\"--dominant-color: #a9b6d0; width:847px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-1024x104.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-300x30.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-768x78.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-600x61.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/image-3-png.avif 1225w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Si necesitas mostrar el promedio final como una letra, puedes usar nuevamente una funci\u00f3n anidada <code>SI<\/code> en otra columna:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SI(D2&gt;=4,\"A\",SI(D2&gt;=3,\"B\",SI(D2&gt;=2,\"C\",SI(D2&gt;=1,\"D\",SI(D2&gt;=0,\"F\",\"\")))))\n<\/code><\/pre>\n\n\n\n<p>Aqu\u00ed, la columna D contendr\u00eda el promedio num\u00e9rico.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">6. Manejo de Errores y Validaci\u00f3n de Datos<\/h3>\n\n\n\n<p>El video tambi\u00e9n destaca la importancia de manejar posibles errores (como celdas en blanco o datos no v\u00e1lidos) utilizando la funci\u00f3n <code>SIERROR<\/code>. Adem\u00e1s, recomienda usar la validaci\u00f3n de datos para asegurar que solo se ingresen letras de calificaci\u00f3n v\u00e1lidas en la Hoja de Datos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Consejos Adicionales para Trabajar con Letras y N\u00fameros en Excel<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udca1 <strong>Utiliza Referencias de Celda<\/strong>: Facilita la copia de f\u00f3rmulas a otras celdas.<\/li>\n\n\n\n<li>\ud83d\udca1 <strong>Mant\u00e9n la Hoja de C\u00f3digos Actualizada<\/strong>: Aseg\u00farate de que la tabla de conversi\u00f3n de letras a n\u00fameros sea correcta.<\/li>\n\n\n\n<li>\ud83d\udca1 <strong>Simplifica con la Funci\u00f3n BUSCARV<\/strong>: Para una tabla de c\u00f3digos m\u00e1s extensa, considera usar la funci\u00f3n <code>BUSCARV<\/code> en lugar de m\u00faltiples funciones <code>SI<\/code> anidadas para una f\u00f3rmula m\u00e1s legible y f\u00e1cil de mantener.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udcbb\ud83d\udd10 \u00a1No Malgastes Dinero! Consigue Windows y Office Originales por Menos \ud83c\udfaf\ud83d\udd25<\/h3>\n\n\n\n<p>\u00bfBuscas licencias originales de Windows y Office a precios accesibles? <strong>\u00a1No sigas pagando de m\u00e1s!<\/strong> En <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> puedes conseguir claves 100% legales y funcionales para tus programas favoritos, con grandes descuentos. Aprovecha el <strong>c\u00f3digo de descuento DH66<\/strong> y obt\u00e9n un precio a\u00fan m\u00e1s bajo. <strong>\u00a1Actualiza tu software sin vaciar tu bolsillo!<\/strong> \ud83d\udcb8\u2705<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Promediar y sumar letras en Excel es un proceso que requiere una conversi\u00f3n inicial a valores num\u00e9ricos, lo que permite el c\u00e1lculo y an\u00e1lisis eficiente. Siguiendo los pasos detallados en este post y las explicaciones del video de YouTube, podr\u00e1s realizar estos c\u00e1lculos de manera eficiente y precisa. \u00a1Esperamos que esta gu\u00eda te sea de gran utilidad!<\/p>\n\n\n\n<p>\u00bfA\u00fan se te complica usar Excel? \ud83d\udcca Es momento de cambiar eso. Con este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso Excel<\/a><\/strong> aprender\u00e1s a utilizar de forma profesional, creando f\u00f3rmulas, automatizando tareas \u2699\ufe0f y analizando datos como un experto \ud83d\udcc8. \u00a1No te quedes atr\u00e1s! \ud83d\ude80 Comienza hoy mismo y destaca en cualquier \u00e1rea que trabajes \ud83d\udcbc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuentes-faq\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-f51469ee uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-836f7d22 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo puedo asignar valores num\u00e9ricos a las letras en Excel para poder promediarlas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes asignar valores num\u00e9ricos a las letras creando una tabla de c\u00f3digos donde defines el valor num\u00e9rico para cada letra (por ejemplo, A=4, B=3, C=2, D=1, F=0). Luego, puedes usar funciones como <code>SI<\/code> anidadas o la funci\u00f3n <code>BUSCARV<\/code> en Excel para buscar el valor num\u00e9rico correspondiente a cada letra en tus datos y as\u00ed poder calcular el promedio.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-6533ef2b \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfExiste una funci\u00f3n directa en Excel para calcular el promedio de letras sin tener que convertirlas a n\u00fameros?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No, Excel no tiene una funci\u00f3n incorporada para promediar letras directamente. Debes convertir las letras a valores num\u00e9ricos primero antes de poder utilizar la funci\u00f3n <code>PROMEDIO<\/code>.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-422288da \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 f\u00f3rmula de Excel es la m\u00e1s recomendada para convertir calificaciones de letras a n\u00fameros?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La f\u00f3rmula recomendada depende de la cantidad de letras que necesites convertir. Para un n\u00famero peque\u00f1o de letras, una serie de funciones <code>SI<\/code> anidadas puede ser suficiente. Sin embargo, para una lista m\u00e1s extensa de letras, la funci\u00f3n <code>BUSCARV<\/code> es generalmente m\u00e1s eficiente y f\u00e1cil de mantener, ya que puedes referenciar una tabla con las letras y sus valores correspondientes.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-8b96b4eb \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfC\u00f3mo puedo evitar errores al promediar letras si algunas celdas est\u00e1n vac\u00edas o tienen valores no v\u00e1lidos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes utilizar la funci\u00f3n <code>SIERROR<\/code> para manejar posibles errores que puedan surgir al intentar convertir celdas vac\u00edas o con valores no v\u00e1lidos a n\u00fameros. Tambi\u00e9n es una buena pr\u00e1ctica utilizar la funci\u00f3n de validaci\u00f3n de datos en Excel para asegurarte de que solo se ingresen las letras de calificaci\u00f3n v\u00e1lidas en las celdas correspondientes.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-eefde55a \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfHay una forma m\u00e1s f\u00e1cil de convertir muchas letras diferentes a n\u00fameros en Excel en lugar de usar m\u00faltiples funciones SI anidadas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, la funci\u00f3n <code>BUSCARV<\/code> es una alternativa m\u00e1s sencilla y eficiente para convertir muchas letras diferentes a n\u00fameros. Primero, crea una tabla de b\u00fasqueda con dos columnas: la primera con las letras y la segunda con sus valores num\u00e9ricos correspondientes. Luego, utiliza la funci\u00f3n <code>BUSCARV<\/code> para buscar el valor num\u00e9rico de cada letra en tu tabla de b\u00fasqueda.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Aprende F\u00e1cil a Promediar y Sumar Letras en Excel \u00bfAlguna vez te has encontrado con la necesidad de promediar o [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":11935,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[225,475,486],"class_list":["post-11932","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-texto","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Promediar y sumar letras en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Promediar y sumar letras en Excel: Aprende f\u00e1cil c\u00f3mo convertir letras a n\u00fameros y usar f\u00f3rmulas para tus c\u00e1lculos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Promediar y sumar letras en Excel f\u00e1cilmente\" \/>\n<meta property=\"og:description\" content=\"Aprende a promediar y sumar letras en Excel f\u00e1cilmente. Convierte calificaciones alfab\u00e9ticas en valores num\u00e9ricos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-13T04:06:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-09T22:07:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Promediar y sumar letras en Excel f\u00e1cilmente\" \/>\n<meta name=\"twitter:description\" content=\"Descubre c\u00f3mo promediar y sumar letras en Excel con m\u00e9todos sencillos y f\u00f3rmulas efectivas. \u00a1Empieza ahora!\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Promediar y sumar letras en Excel\",\"datePublished\":\"2020-02-13T04:06:24+00:00\",\"dateModified\":\"2025-04-09T22:07:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\"},\"wordCount\":878,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg\",\"keywords\":[\"Excel\",\"Texto\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\",\"name\":\"Promediar y sumar letras en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg\",\"datePublished\":\"2020-02-13T04:06:24+00:00\",\"dateModified\":\"2025-04-09T22:07:02+00:00\",\"description\":\"Promediar y sumar letras en Excel: Aprende f\u00e1cil c\u00f3mo convertir letras a n\u00fameros y usar f\u00f3rmulas para tus c\u00e1lculos.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg\",\"width\":500,\"height\":376,\"caption\":\"Promediar letras en excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Promediar y sumar letras en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\",\"url\":\"https:\/\/dostinhurtado.com\/site\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\/\/dostinhurtado.com\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Promediar y sumar letras en Excel - Dostin Hurtado","description":"Promediar y sumar letras en Excel: Aprende f\u00e1cil c\u00f3mo convertir letras a n\u00fameros y usar f\u00f3rmulas para tus c\u00e1lculos.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Promediar y sumar letras en Excel f\u00e1cilmente","og_description":"Aprende a promediar y sumar letras en Excel f\u00e1cilmente. Convierte calificaciones alfab\u00e9ticas en valores num\u00e9ricos.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2020-02-13T04:06:24+00:00","article_modified_time":"2025-04-09T22:07:02+00:00","og_image":[{"width":500,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Promediar y sumar letras en Excel f\u00e1cilmente","twitter_description":"Descubre c\u00f3mo promediar y sumar letras en Excel con m\u00e9todos sencillos y f\u00f3rmulas efectivas. \u00a1Empieza ahora!","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Promediar y sumar letras en Excel","datePublished":"2020-02-13T04:06:24+00:00","dateModified":"2025-04-09T22:07:02+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/"},"wordCount":878,"commentCount":4,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg","keywords":["Excel","Texto","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/","name":"Promediar y sumar letras en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg","datePublished":"2020-02-13T04:06:24+00:00","dateModified":"2025-04-09T22:07:02+00:00","description":"Promediar y sumar letras en Excel: Aprende f\u00e1cil c\u00f3mo convertir letras a n\u00fameros y usar f\u00f3rmulas para tus c\u00e1lculos.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg","width":500,"height":376,"caption":"Promediar letras en excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/promediar-y-sumar-letras-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Promediar y sumar letras en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web-300x226.jpg",300,226,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web.jpg",500,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2020\/02\/promedio_letras_web-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":4,"uagb_excerpt":"Aprende F\u00e1cil a Promediar y Sumar Letras en Excel \u00bfAlguna vez te has encontrado con la necesidad de promediar o [&hellip;]","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/11932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=11932"}],"version-history":[{"count":2,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/11932\/revisions"}],"predecessor-version":[{"id":25293,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/11932\/revisions\/25293"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/11935"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=11932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=11932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=11932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}