Dynamic SUM Formula with XLOOKUP (feat TAKE and DROP)

[@Computergaga]

📚 Learn more than 150 Excel functions with 'Advanced Excel Formulas' - amzn.to/3Rg87Go

[@mazenzagha8811]

Dear sir
Thanks for this video
Sir could you please help me 🙏
Sir i need to save and print the form it self on one page only
Sir i try many times and i can't
Sir what is the codes for this
If you have vidio or link pls provided
Thanks again

[@ExcelWithChris]

Love these short "combination" formulas. Thanks!!!

[@Computergaga]

You're so welcome! Thank you, Chris.

[@vacilando86]

Last 6 months average, median, percentile or even forecast ets function can be used via this method. Brilliant

[@Computergaga]

Absolutely! Thank you for your comments.

[@kebincui]

Very clearly and elegantly explained ❤👍. Thank you Alan.

[@Computergaga]

Thank you Kebin.

[@ExcelWithChris]

🙌🙌

[@andrewjohnston2586]

Great vid; why do you say the data is in a terrible layout for data analysis?

[@Computergaga]

Thank you Andrew.
Because the data is in a Pivot style layout with month names along the header row. Month names are data and should really be in a column named 'Month Name' so the data could be filtered, sorted or calculated using the month.

[@nadermounir8228]

Thank u Alan for this great video 📹 👍

[@Computergaga]

My pleasure! Thank you Nader.

[@tanveerabbas3271]

great as always. this time you did not attach sample data

[@Computergaga]

Thank you Tanveer. The sample file has been added.

[@Hello-bn2yc]

Thank you Andy for sharing that tip

[@Computergaga]

No problem 👍

[@tomshaw9065]

I can already think of some applications of this for where I work. Excellent example to make us look outside our usual functions!

[@Computergaga]

Fantastic! Thank you Tom.

[@Seftehandle]

Great video as always. Video suggestion: explain the absolute and relative references in a formatted table

[@Computergaga]

Thank you 😊
I have a video here ruclips.net/video/JjYbuHa1YYQ/видео.html
Absolute references in Tables are awkward.

[@thebhaskarjoshi]

Loved this ❤

[@Computergaga]

Thank you 😊

[@MrDhunpagla]

More like these pls.... This is absolutely fantastic.... Thanks

[@Computergaga]

Thank you 😊 I hope to deliver more.

[@SKL1412]

Good idea

[@Computergaga]

Thank you.

[@khanabdussabur8604]

Absolutely helpful, Thanks a lot.

[@Computergaga]

You're welcome! Thank you.