Year to Date (YTD) Analysis in #Excel || Sum a Dynamic Range with INDEX/MATCH and XLOOKUP

In this video, you will learn the meaning of YTD analysis and the period it covers, the difference between YTD and YoY and how to sum a dynamic range with Index/Match and Xlookup. Please check out other videos on my channel and don't forget to comment, like, share, subscribe and click the bell icon so you'll get a notification when the next video is uploaded. Thanks! Content 00:03 Intro 00:26 Meaning of YTD analysis 00:54 The period YTD covers 01:43 Difference between YTD and YoY 02:36 Presentation of YTD analysis 03:19 Basic sum of range 04:19 Sum a dynamic range with Index/Match 06:51 Sum a dynamic range with Xlookup 08:20 Conclusion Connect with me on: 👉Instagram and Facebook @youexceltutorials 👉Twitter @youexceltutor 👉LinkedIn @bunmisanusi 🎬Check these videos: XLOOKUP || INDEX/MATCH https://youtu.be/gAU7gT4sizk Year-Over-Year (YoY) analysis https://youtu.be/2PtlrBzedB4 EBITDA Bridge || Waterfall Chart https://youtu.be/lAUcqDp3A7M 🔽Download the file here https://docs.google.com/spreadsheets/d/10F3_z2oAecasIho1RJGdT-mdG5LeoCqQ/edit?usp=sharing&ouid=112939358226643879339&rtpof=true&sd=true 📢“As the mountains surround Jerusalem, so the LORD surrounds his people both now and forevermore.” Psalm 125:2 (NIV) #msexcel #youexceltutorials