Non-array formula to count non-duplicates

I have a spreadsheet containing database output that I use frequently for running quick "queries" by using the filter feature. On a separate tab, I have some commonly used values calculated and displaying as a cover page of sorts.

The problem I'm having is that my filters have fairly suddenly started slowing WAY down, taking 5-15 seconds instead of 1-2 seconds. Since I'm usually filtering multiple columns to do what I want to do, this is somewhat annoying. It seems likely that the couple of array functions I used on my cover page are the problem - deleting those resolves it and filters take a second or so once again (though I'm not sure what triggered this - the array functions are not new - maybe the dataset just got too long? If there's some other solution to this, that would be even better).

So, I am looking for a new way to accomplish what they are doing. Essentially, I have 2 columns - Property Name and Property Type. There can be multiple entries for the same property name. The array function is counting the number of different property names with a given property type.

Ex.

Property Name	Parcel Name	Property Type
Property 1	Parcel 1	Type A
Property 1	Parcel 2	Type A
Property 1	Parcel 3	Type A
Property 2	Parcel 1	Type B
Property 3	Parcel 1	Type A
Property 3	Parcel 2	Type A

I would want this to return "2", as there are two distinct Property Names that have Property Type A. Naturally, my formula is actually slightly more complicated, relying on a couple other filters as well, but that's the gist of it. Is there another way to do this? Not at all familiar with VBA but willing to give it a try.