Remember 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...
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.
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!
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.