First, let me say that I've read several threads on here regarding this issue but I haven't been able to make it work. So I've attached a sample spreadsheet.
I filter on the region and count the "Building" column based on 3 criteria:
Status = "Established"
Total >= 150
Cell I5 has the COUNTIFS formula.
Cell H5 uses SUMPRODUCT and SUBTOTAL and works with filtering but I can only get it to work with 1 criteria. I don't really understand how it work so that makes it really difficult to modify for 3 criteria.