How to get SUMIF of visible cells only?

Question

Google Sheets

https://docs.google.com/spreadsheets/d/1NU13NCXs4W...
Here is the link to the spreadsheet.
How to get the sum of the values ​​in the cells, provided that these cells are visible after the filter and satisfy a certain value in the neighboring cell?
For example, there are subtotals - it counts only visible values, but there is no condition. There is a sum if - there is a condition but it counts all values, both visible and hidden. Unable to merge. It is desirable to solve this issue without additional lists and scripts.

Answer 1

Not really, but I think it will help. Use FILTER ( Range;Condition1;Condition2;...ConditionN ) to calculate the sum.
for example, in your case, in B47 we write:
Where A47 is a filter condition for the diameter of the pipeline
. Better yet, do it right away:

=ЕСЛИОШИБКА(СУММ(FILTER($C$2:$C$45;$B$2:$B$45=A47));0)