How to count rows based on multiple criteria

I am trying to design a formula that will count the number of rows that meet certain criteria. The criteria are that status equals either 'active' or 'inactive', and that the region equals a certain region(s).

I have attached a sheet that has a sample of data (data tab), and my formula on the results tab. If, for instance, I want to find all 'Active' status with a region of 'South', I have been using this formula (Note: I am using named ranges here): =SUMPRODUCT((Status="Active")*(ISNUMBER(SEARCH("South",Region)))) which works as expected.

Where I am running into trouble is when I try to incorporate an 'OR' into this. For instance, all 'Active' accounts where the region equals 'South' OR 'West'. I have tried incorporating an OR into the formula in many different places, but to no avail. And when I use: =SUMPRODUCT((Status="Active")*(ISNUMBER(SEARCH("South",Region)*(ISNUMBER(SEARCH("West",Region)*)))))) , it functions like an 'AND' statment.

Any help would be GREATLY appreciated.

Cheers,

Jack