How to SUM Only Visible (or Filtered) Rows Using SUBTOTAL

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.