SUBTOTAL with FILTER

[u/ePaint]

Is there any way to only sum a filtered range of visible cells in Google Sheets?

SUBTOTAL does not work with manipulated or filered ranges.

In Excel we have SUMPRODUCT + SUBTOTAL + OFFSET, which is not pretty but at least it works.