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 ► https://www.xelplus.com/courses/

LINK to more YouTube Shorts videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxLSnxEsaULkdYPgKuTtn84

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://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