Download the SUBTOTAL Example File
You can experiment with the filters in the file below to see SUBTOTAL at work. You can download the spreadsheet used as an example in this tutorial by clicking on the green Excel button in the bottom right of the embedded file below.
Get the latest Excel tips and tricks by joining the newsletter!
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it. You can read more of his writing on his personal blog at NapkinMath.io.
Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!