Excel FILTER FUNCTION with 2 Criteria - Not working (?)

[rob1963manwork]

Hello!

Adding the 2nd criteria is resulting in a value error, removing the 2nd criteria will produce desired results. Why is this clear cut issue creating a problem of some kind? I reached out for help in YOUTUBE and elsewhere but they do it the same as I'm doing it with the exception that they put ,"") after the end but that doesn't work either when i do it.

1. '=FILTER(D6:E7,D6:D7="MARIA") This is working for me
2. '=FILTER(D6:E7,D6:D7="MARIA")*(E6:E7="STEVENS") This results in #VALUE! error.

Any insight would be appreciated!

[WideBoyDixon]

Like this:

Please Login or Register  to view this content.

WBD

[rob1963manwork]

Like this:

Please Login or Register  to view this content.

WBD

Hi WideBoyDixon

thanks for the help!!

• Here is a sample of the REAL scenario: FILTER(Table1,(Table1[Row Type]="Data")*(Table1[Data Type]="detail credits"))*(Table1[Data Type]="detail credits")
• Changed it to this: FILTER(Table1,((Table1[Row Type]="Data")*(Table1[Data Type]="detail credits"))*(Table1[Data Type]="detail credits"))

and it worked like a charm! Darn those parenthesis!!