Filter Formula won't produce results

Occasional Visitor

I am attempting to build a table using Option/Radio buttons. I have built one table successfully, however I cannot get this FILTER formula to pull the correct data from my Master Table. Although I do not get an error, the formula just produced 0's where there should definitely be data. I used identical formulas and referencing to build a working FILTER formula so any suggestions as to the cause of this is appreciated.Capture02.17.PNG

2 Replies


=FILTER(BT3:BW55;BT2:BW2=ERSTERWERT(CB1;1;"Trailer Shipments";2;"TB Shipments";3;"Trailer Production";4;"TB Production"))

This formula seems to be the german translation of your formula and works well in my spreadsheet. 


Without FILTER().