Excel Sumproduct with If or count?

Question

I'm close to solving the formula, but am stuck on excluding specific words and connecting to a specific place in the formula. I work with one data set and should do the counting for a specific location, but exclude certain names in this quantity. I have just a few words, but, for example, I want to eliminate Classpass(1) Class, Classpass, LAclasspass. But at the same time, I want to make it location specific.

This is the formula that I now have.

=SUMPRODUCT((Series<>"1- One Class (ClassPass)")*(Series<>"Classpass (1) Class")*(Series<>"LA - ClassPass - 1 Class")*(Series<>""))

But how do I get attached to a certain place. This only gives me the total of everything in the dataset. Because in the data I have 30 different localizations, but I only want to count and exclude names for one particular studio at a time.

The first image is the data, and the second image is the sheet where I want to make a formula and a link to a specific place. If I were unclear, just ask me any further questions.

Answer 1

As ASH replied: I’m not sure that I got it completely, but only in order to stimulate further clarification. How about adding * (ROOM = B4) to this SumProduct?

Accept this answer and help close this question.