If you’re looking for an easy way to add a total row to a filtered Excel table, this video has you covered! In just one click, you can add the total row and select what function you’d like it to display. You can choose from Sum, Average, Count, Max, Min, and more – no need to write formulas. Plus, the SUBTOTAL function ensures the total row will only display the totals for the visible cells. So, if you filter out rows, the values from those cells will automatically be removed from the total row – it’s that easy!

Please take the opportunity to connect and share this video with your friends and family if you find it useful.