Subtotal filtered columns

I have read several posts on this issue and none do what I want.

Say I have 4 columns and 7 rows. I want to filter Column 3 on a criteria. When I filter I now have 3 rows instead of 7 displayed ( Not necessarily starting at Row 2 but maybe Row 4 if that is where the first data is from that filter). I want to total only the values of Column 4 that match the filter in Column 2 (which may change next time I filter).

Unflitered Table Example

I want the total ages of the women so the filtered table looks like this

So the answer should be 150. And if I filter on Males the table would look like this

And the answer should be 69