The SOUS.TOTAL (SUBTOTAL) function calculates a sum, average, count or other summary, choosing the calculation with a numeric code, and ignoring rows hidden by a filter depending on the code used. It also avoids double-counting other subtotals. It therefore gives a total that follows the filter.
Example
=SOUS.TOTAL(109;B2:B100) // sum of the visible rows