Filter Formula with multiple conditions

[mstgier]

Good evening,

I am struggling with the Filter function, where I try to filter 3 conditions. Even I thought,
I did understand it, I must admit, I don't

As seen in the Test file, I have in Sheet1 a table called "Test" with 4 Columns:

- Person
- Region
- Responsibility
- District

When I filter in Sheet2 in Cell: D7, using the formula:

=FILTER(TEST,TEST[Region]="R")

I get the result as expected.

If I try to extend the formula to filter for the Region and for the Responsibility as seen in Cell: D14,
I fail terribly

I tried with:
=FILTER(Test,Test[Region]="R")*(Test[Responsible]="Single") and also with several other attempts.


The target is, to have a filter, where I filter by Region="R", Responsibility="Single" and District="11",

where I should end with:

Person A
Person C

Can someone help?

Thank you very much