Sum variable and custom ranges with XLOOKUP: the Victor Momoh Edition

I was on a couple of Meetup Zoom calls and Victor Momoh was the guest. He showed some fascinating stuff by using XLOOKUP to retrieve a range of data. He then used it to make sums and all kinds of other cool things. I share some of that in this video with you. 0:00 Introduction 0:24 My trip to Lagos 3:35 Using XLOOKUP to create the sum of a variable range 6:15 Using XLOOKUP to sum a variable range with variable start and end points 7:20 Using XLOOKUP and OFFSET to calculate variable distances 9:00 Outro Victor Momoh presenting at the Saudi Arabia Excel Meetup Group.    • The Versatile Lookup Functions with Victor...   See Victor Momoh explain XLOOKUP returning a range instead of a value    • Getting Hyper with Hyperlinks | Victor Momoh   Victor's YouTube channel:    / excelmoments   Download the workbook in this video: https://datascopic.net/momoh #XLOOKUP #SumRange #CalculateDistance For a list of my Excel courses at Lynda/LinkedIn:   / oz-du-soleil   There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday. Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analy... My old blog: http://datascopic.net/blog-2-2