How to subtotal only if certain conditions apply

You're welcome.

Originally Posted by RunwayRiga

I think that, when counting a column with subtotal, in particular a column that is not visible, the result is 0, right? That is why, if you add in the conditions that the result of the subtotal(2;xx) must be 1, you immediately cut out all the rows that are not visible. I hope this is the explanation)

Yes, that's exactly how it works, except it's for visible rows, not columns...