Скачать или смотреть Dynamic SUM Formula with XLOOKUP (feat TAKE and DROP)

Create a dynamic SUM formula with XLOOKUP in Excel.

The XLOOKUP function in Excel really changed how we lookup and return dynamic values. We no longer rely on the INDEX function so much and the gymnastics involved.

Learn more than 150 Excel formulas https://amzn.to/3Rg87Go

⌚ Video chapters
00:00 - Dynamic SUM with XLOOKUP formula
01:56 - Searchable list with dynamic SUM
02:18 - Sum the last 6 months only
03:33 - DROP function to remove the first column
04:26 - TAKE function to extract the last 6 columns

📚 Resources
Sample file - https://computergaga.com/_excel/files...

This video shows two examples of a dynamic sum formula. The first to sum all values from a given row and the second to sum the last 6 months only. The Excel formula will be fully dynamic.

Find more great free tutorials at; https://www.computergaga.com

** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!
LinkedIn ►   / alanmurray-computergaga  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1  

#xlookup #excelformulas #excel365