Filter Formula with multiple conditions

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

hmmmm,

and when I would like to add a third condition as in the file, I get a #CALC error, so it is me

Thank you so much for your help Glenn

I do agree with you but I would prefer it with a formula... pivot table will come next week.

Thanx a lot for your help and support.

You need to remove the quotes from the 12, otherwise it's looking for text & not a number.

Arrrrghhhh those bloody quotes... that did the trick... thank you so much Fluff

Glad to help & thanks for the feedback.

Short INFO,

I have been playing around with Filter in a huge table with around 100 Columns, where I all the time run into a Value error. I was able to fix it, by
Filtering from the right to the left. If I tried to filter from the left to the right, I had all the time an error, just in case it happens to you also, try from
the right, it might helps...