{"id":23361,"date":"2025-01-29T12:30:00","date_gmt":"2025-01-29T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=23361"},"modified":"2025-04-04T16:30:58","modified_gmt":"2025-04-04T21:30:58","slug":"sumar-en-rango-de-fechas","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/","title":{"rendered":"Sumar en Rango de Fechas"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-3-formas-de-sumar-entre-rango-de-fechas-en-excel\">3 Formas de Sumar entre Rango de Fechas en Excel<\/h1>\n\n\n\n<p>\u00bfQuieres aprender a sumar entre un rango de fechas en Excel de forma eficiente? En este tutorial te explicamos <strong>tres m\u00e9todos diferentes<\/strong> que puedes aplicar f\u00e1cilmente: filtros, tablas din\u00e1micas y funciones. Todos estos m\u00e9todos te permiten trabajar con tus datos de manera ordenada, precisa y profesional. Adem\u00e1s, te dejamos ejercicios pr\u00e1cticos para reforzar lo aprendido.<\/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=\"3 Formas de Sumar entre Rango de Fechas en Excel + Ejercicios \ud83d\ude80\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/OQiTRyHC50w?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-7d2abe\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-0a60c3 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.zip\" 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\" id=\"h-1-usar-filtros-para-sumar-en-rango-de-fechas\">1. Usar filtros para Sumar en Rango de Fechas<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"ececec\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"646\" height=\"284\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-png.avif\" alt=\"Registro de asistencia din\u00e1mico en Excel, mostrando la estructura de la tabla con nombres y d\u00edas de la semana para el seguimiento de la asistencia.\" class=\"wp-image-25150 has-transparency\" style=\"--dominant-color: #ececec; width:546px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-png.avif 646w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-300x132.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-600x264.avif 600w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfC\u00f3mo hacerlo?<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Convierte tu rango de datos en una tabla (Ctrl + T).<\/li>\n\n\n\n<li>Aplica un filtro en la columna de fecha.<\/li>\n\n\n\n<li>Usa el filtro de fecha \u00abEntre&#8230;\u00bb para seleccionar tu rango deseado.<\/li>\n\n\n\n<li>Activa la <strong>fila de totales<\/strong> en la tabla para obtener la suma autom\u00e1tica.<\/li>\n<\/ul>\n\n\n\n<p><strong>Ventaja:<\/strong> R\u00e1pido y visual.<br><strong>Desventaja:<\/strong> Es una soluci\u00f3n temporal; modifica los datos visibles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-usar-tablas-dinamicas-para-sumar-en-rango-de-fechas\">2. Usar tablas din\u00e1micas para Sumar en Rango de Fechas<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f0f0f0\" data-has-transparency=\"true\" decoding=\"async\" width=\"426\" height=\"719\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-1-png.avif\" alt=\"Ventana de &quot;Campos de tabla din\u00e1mica&quot; en Excel, mostrando la selecci\u00f3n de campos para generar un informe que suma valores por meses y a\u00f1os.\" class=\"wp-image-25151 has-transparency\" style=\"--dominant-color: #f0f0f0; width:220px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-1-png.avif 426w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-1-178x300.avif 178w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfC\u00f3mo se hace?<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inserta una tabla din\u00e1mica desde tu tabla original.<\/li>\n\n\n\n<li>Coloca las fechas en las filas (en lugar de filtros).<\/li>\n\n\n\n<li>Agrupa y ordena los campos seg\u00fan lo necesites.<\/li>\n\n\n\n<li>Usa el filtro de fechas en las filas para seleccionar el rango deseado.<\/li>\n\n\n\n<li>Excel agrupa y suma autom\u00e1ticamente los datos.<\/li>\n<\/ul>\n\n\n\n<p><strong>Ventaja:<\/strong> Muy profesional, ideal para informes y gr\u00e1ficos.<br><strong>Desventaja:<\/strong> Crea una nueva hoja y puede requerir m\u00e1s pasos para sumar en rango de fechas.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"eaeaeb\" data-has-transparency=\"true\" decoding=\"async\" width=\"111\" height=\"128\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-2-png.avif\" alt=\"\" class=\"wp-image-25152 has-transparency\" style=\"--dominant-color: #eaeaeb; aspect-ratio:1;width:126px;height:auto\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-usar-la-funcion-sumar-si-conjunto-para-sumar-en-rango-de-fechas\">3. Usar la funci\u00f3n SUMAR.SI.CONJUNTO para Sumar en Rango de Fechas<\/h2>\n\n\n\n<p>Este m\u00e9todo es ideal cuando necesitas el resultado en una sola celda.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Sintaxis usada en el ejemplo:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"f0f0f1\" data-has-transparency=\"true\" style=\"--dominant-color: #f0f0f1;\" loading=\"lazy\" decoding=\"async\" width=\"855\" height=\"62\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-3.png\" alt=\"F\u00f3rmula de Excel que utiliza la funci\u00f3n SUMAR.SI.CONJUNTO para sumar valores dentro de un rango de fechas espec\u00edfico.\" class=\"wp-image-25153 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-3.png 855w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-3-300x22.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-3-768x56.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-3-600x44.avif 600w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SUMAR.SI.CONJUNTO(<br>  ventas[valor],<br>  ventas[fecha], \">=01\/12\/2024\",<br>  ventas[fecha], \"&lt;=15\/12\/2024\"<br>)<br><\/code><\/pre>\n\n\n\n<p>Tambi\u00e9n puedes a\u00f1adir m\u00e1s condiciones, por ejemplo, si solo deseas sumar las ventas hechas en efectivo:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"eeecee\" data-has-transparency=\"true\" style=\"--dominant-color: #eeecee;\" loading=\"lazy\" decoding=\"async\" width=\"852\" height=\"55\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-4.png\" alt=\"\" class=\"wp-image-25154 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-4.png 852w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-4-300x19.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-4-768x50.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/image-4-600x39.avif 600w\" sizes=\"(max-width: 852px) 100vw, 852px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>=SUMAR.SI.CONJUNTO(<br>  ventas[valor],<br>  ventas[fecha], \">=01\/12\/2024\",<br>  ventas[fecha], \"&lt;=15\/12\/2024\",<br>  ventas[m\u00e9todo de pago], \"efectivo\"<br>)<br><\/code><\/pre>\n\n\n\n<p><strong>Ventaja:<\/strong> Preciso, ordenado, no altera tus datos.<br><strong>Desventaja:<\/strong> Puede ser m\u00e1s complejo al inicio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-cual-metodo-es-mejor-para-sumar-en-rango-de-fechas\">\u00bfCu\u00e1l m\u00e9todo es mejor para Sumar en Rango de Fechas?<\/h2>\n\n\n\n<p>Depende del contexto. Si est\u00e1s en una entrevista de trabajo, usando <strong>tablas din\u00e1micas o funciones<\/strong> demuestra mayor dominio de Excel. Si solo necesitas una soluci\u00f3n r\u00e1pida, sumar con el filtro puede ser suficiente.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u00bfD\u00f3nde puedo conseguir una licencia de Excel?<\/h3>\n\n\n\n<p>Puedes adquirir una licencia vitalicia a bajo costo en <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong>, usando el <strong>c\u00f3digo de descuento DH66<\/strong> para obtener un <strong>66% de descuento<\/strong>. Estas herramientas son ideales para sumar en rango de fechas, ya que ayudan tanto a estudiantes como a profesionales.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Sumar entre un rango de fechas en Excel es m\u00e1s f\u00e1cil de lo que parece. Ya sea que uses filtros, tablas din\u00e1micas o funciones, lo importante es que <strong>sepas cu\u00e1l herramienta aplicar seg\u00fan tu necesidad.<\/strong> Si quieres dominar Excel para el trabajo o tus estudios, esto ser\u00e1 esencial para sumar en rango de fechas.<\/p>\n\n\n\n<p>\u00bf<strong>A\u00fan usas Excel solo para hacer tablas b\u00e1sicas?<\/strong> \ud83d\udcca\ud83d\ude05 Es hora de ir m\u00e1s all\u00e1. Con este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> aprender\u00e1s a <strong>automatizar tareas<\/strong>, crear <strong>gr\u00e1ficos din\u00e1micos<\/strong>, usar <strong>f\u00f3rmulas complejas<\/strong> y mucho m\u00e1s \ud83d\udd04\ud83d\udcc8\ud83d\udca1. No esperes a que te lo pidan en el trabajo \ud83d\udcbc\u23f3, <strong>adel\u00e1ntate y capac\u00edtate hoy mismo<\/strong> \ud83d\ude80\ud83d\udcda.<\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-ff21392a\"><h2 class=\"uagb-heading-text\">Preguntas Frecuentes (FAQ)<\/h2><\/div>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-fad2fce3 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-b06f318c \" 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>\u00bfCu\u00e1l es el m\u00e9todo m\u00e1s r\u00e1pido para sumar valores dentro de un rango de fechas?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>&#8211; El m\u00e9todo m\u00e1s r\u00e1pido depende de la situaci\u00f3n:<br>&#8211; Para an\u00e1lisis r\u00e1pidos, utiliza <strong>filtros<\/strong>.<br>&#8211; Si necesitas an\u00e1lisis detallados, las <strong>tablas din\u00e1micas<\/strong> son ideales.<br>&#8211; Para un resultado en una sola celda, usa <strong>SUMAR.SI.CONJUNTO<\/strong>.<br>Cada m\u00e9todo tiene su lugar seg\u00fan tus necesidades y el tipo de tarea que est\u00e9s realizando.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b2c0e443 \" 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 ventajas tienen las tablas din\u00e1micas sobre los filtros?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Las tablas din\u00e1micas ofrecen una mayor flexibilidad y permiten:<br>&#8211; Agrupar y organizar datos autom\u00e1ticamente.<br>&#8211; Crear gr\u00e1ficos din\u00e1micos que se actualizan en tiempo real.<br>&#8211; Analizar datos desde diferentes perspectivas sin alterar la tabla original.<br>En cambio, los filtros son \u00fatiles para tareas r\u00e1pidas, pero menos vers\u00e1tiles.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-05e3d58d \" 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>\u00bfPuedo usar SUMAR.SI.CONJUNTO en versiones antiguas de Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n <strong>SUMAR.SI.CONJUNTO<\/strong> est\u00e1 disponible a partir de Excel 2007. Si utilizas una versi\u00f3n anterior, considera actualizar tu software o usar alternativas como tablas din\u00e1micas para lograr resultados similares.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-82bf1d03 \" 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 automatizar este proceso?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes automatizar el proceso utilizando <strong>macros<\/strong> en Excel. Una macro puede grabar los pasos que sigues y ejecutarlos autom\u00e1ticamente con un clic. Esto es especialmente \u00fatil si realizas tareas repetitivas.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-d993e562 \" 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 hacer si no tengo acceso a Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si no tienes Excel, puedes utilizar alternativas gratuitas como <strong>Google Sheets<\/strong> o <strong>LibreOffice Calc<\/strong>, que ofrecen funciones similares. Por ejemplo, en Google Sheets, puedes usar la f\u00f3rmula <code>=SUMIFS<\/code> para obtener resultados equivalentes.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.<\/p>\n","protected":false},"author":3,"featured_media":23384,"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,236,266,459],"class_list":["post-23361","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel","tag-fechas","tag-funciones","tag-sumar","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>Sumar en Rango de Fechas - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.\" \/>\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\/sumar-en-rango-de-fechas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sumar en Rango de Fechas en Excel F\u00e1cilmente\" \/>\n<meta property=\"og:description\" content=\"Aprende a sumar en rango de fechas en Excel con tres m\u00e9todos sencillos. Mejora tu manejo de datos hoy mismo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2025-01-29T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-04T21:30:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\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=\"Sumar en Rango de Fechas: M\u00e9todos \u00datiles\" \/>\n<meta name=\"twitter:description\" content=\"Descubre c\u00f3mo sumar en rango de fechas en Excel. Te ense\u00f1amos filtros, tablas din\u00e1micas y funciones para que lo apliques.\" \/>\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=\"4 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\/sumar-en-rango-de-fechas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292\"},\"headline\":\"Sumar en Rango de Fechas\",\"datePublished\":\"2025-01-29T17:30:00+00:00\",\"dateModified\":\"2025-04-04T21:30:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\"},\"wordCount\":551,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif\",\"keywords\":[\"Excel\",\"Fechas\",\"Funciones\",\"sumar\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\",\"name\":\"Sumar en Rango de Fechas - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif\",\"datePublished\":\"2025-01-29T17:30:00+00:00\",\"dateModified\":\"2025-04-04T21:30:58+00:00\",\"description\":\"Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif\",\"width\":1000,\"height\":750,\"caption\":\"Sumar valores entre dos fechas\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sumar en Rango de Fechas\"}]},{\"@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\/8af4c9d419341db13542ef727f0e0292\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/daniel\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Sumar en Rango de Fechas - Dostin Hurtado","description":"Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.","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\/sumar-en-rango-de-fechas\/","og_locale":"es_ES","og_type":"article","og_title":"Sumar en Rango de Fechas en Excel F\u00e1cilmente","og_description":"Aprende a sumar en rango de fechas en Excel con tres m\u00e9todos sencillos. Mejora tu manejo de datos hoy mismo.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/","og_site_name":"Dostin Hurtado","article_published_time":"2025-01-29T17:30:00+00:00","article_modified_time":"2025-04-04T21:30:58+00:00","og_image":[{"width":1000,"height":750,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Sumar en Rango de Fechas: M\u00e9todos \u00datiles","twitter_description":"Descubre c\u00f3mo sumar en rango de fechas en Excel. Te ense\u00f1amos filtros, tablas din\u00e1micas y funciones para que lo apliques.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8af4c9d419341db13542ef727f0e0292"},"headline":"Sumar en Rango de Fechas","datePublished":"2025-01-29T17:30:00+00:00","dateModified":"2025-04-04T21:30:58+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/"},"wordCount":551,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif","keywords":["Excel","Fechas","Funciones","sumar"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/","name":"Sumar en Rango de Fechas - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif","datePublished":"2025-01-29T17:30:00+00:00","dateModified":"2025-04-04T21:30:58+00:00","description":"Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif","width":1000,"height":750,"caption":"Sumar valores entre dos fechas"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/sumar-en-rango-de-fechas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Sumar en Rango de Fechas"}]},{"@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\/8af4c9d419341db13542ef727f0e0292","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/275749aad03534aea916e76323728243.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif",1000,750,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-150x150.avif",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-300x225.avif",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-768x576.avif",768,576,true],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif",1000,750,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif",1000,750,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif",1000,750,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas.avif",1000,750,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-870x570.avif",870,570,true],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-600x750.avif",600,750,true],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-600x600.avif",600,600,true],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-400x400.avif",400,400,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-600x450.avif",600,450,true],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2025\/01\/Sumar-valores-entre-dos-fechas-100x100.avif",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/daniel\/"},"uagb_comment_info":0,"uagb_excerpt":"Aprende a sumar en rango de fechas en Excel con filtros, tablas din\u00e1micas y funciones simples paso a paso.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23361","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=23361"}],"version-history":[{"count":3,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23361\/revisions"}],"predecessor-version":[{"id":25156,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/23361\/revisions\/25156"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/23384"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=23361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=23361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=23361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}