How to sum a filtered range data in excel

To sum data on a filtered range use subtotal formula, with parameter 9 for sum. The structure of the formula would be like this =subtotal(9,D5:D1100).

For example, When you filter data in┬áthe┬ácolumn “D”, from range D400 to D520 and D720 to D725. Subtotal formula automatically sum this noncontiguous range.

Contact Us

Learn Excel Tricks