Channel: Leila Gharani

Category: Education

Tags: excel tips and tricksexcel total filtered listexcel tablemicrosoft excel tutorialsexcel for analystsmicrosoft excelquick tipsxelplusvisleila gharaniadvanced excel tricksmicrosoft excel tutorialexcel 2016excel 2019xelplusmicrosoft 365excel 2013excel online courseexcel filtered listexcel 365excel add total rowexcel subtotalshorts

Description: Adding a Total Row to a filtered Excel table just takes 1 click! If you want the AVERAGE or COUNT instead, you make a selection from the drop-down list. No need to write your formulas. You can also add a function from the total row drop-down like Sum, Average, Count, Max, Min, etc. The total row automatically applies the SUBTOTAL function which will only display the totals for any visible cells. So, if you filter out rows, the values from those cells will automatically be removed from the total row. 🌍 My Online Excel Courses ► xelplus.com/courses 🎬 LINK to more YouTube Shorts videos: youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel