Excel's subtotaling feature is a great tool for inserting subtotaling formulas in into your data. The down side is that the subtotal rows are often difficult to discern from the rest of the data.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results