Excel Tip Tuesday: Subtotals (for those filtered columns from last week)

Posted by Lisa on August 14, 2018 at 9:30 AM

Excel IconRemember last week when we learned how to use Auto Filters? Well, what if you need totals for those spiffy new filtered columns of yours? Use the SUBTOTAL function! And it’s seriously easy when you already have a filtered list. Go to the bottom of the column and click the AutoSum button on the Home Tab...

Excel Tips - Subtotals1

Instead of a SUM function, Excel automatically recognizes what you're doing and inserts the SUBTOTAL function. If you want to add everything in that column, then just press enter and you’re done.

Excel Tips - Subtotals2

But hold on a second. Did you know you can do more than just add with the SUBTOTAL function? Click in the formula box at the top and then click in the formula. All the options for the function_num will show, so you can quickly select count, average, whatever you'd like!

Excel Tips - Subtotals3

That should save you a few extra steps.

Leave us a comment and let readers know what Excel tips you use on a daily basis.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts