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.