Filter function, adding another variable inside as a range

[Hapakaya]

Hello, I currently have a table of data that I filter through. The variables use to filter include manufacturer, tonnage and type. These can all be listed as "All" or only some, or they can all be specified. However, in my tonnage drop down list I only have a specific tonnage. IE 2,3,4,5.... I would like to add in the drop down list "Range" and then I have another drop down list area that I will specify a min and max tonnage value.
Here is a snap of my search sheet.

And here is the formula I use (Thanks Fluff):
=LET(Rws,SEQUENCE(ROWS(Tab!C3:C702),,,0),FILTER(Tab!F3:Z702,(IF(B9="All",Rws,Tab!D3:D702=B$9))*(IF(C9="All",Rws,Tab!C3:C702=C$9))*(IF(D9="All",Rws,Tab!E3:E702=D$9))))

Here is some more context for cell data:

and the sheet that Im using to provide the data:

 

[Fluff]

Will C9 only have All or Range?

 

[Hapakaya]

Will C9 only have All or Range?

Ideally I would like, All, Range, and the full list of specific tons

 

[Fluff]

Ok, how about

=LET(Rws,SEQUENCE(ROWS(Tab!C3:C702),,,0),FILTER(Tab!F3:Z702,(IF(B9="All",Rws,Tab!D3:D702=B$9))*(IF(C9="All",Rws,IF(C9="Range",(Tab!C3:C702>=H9)*(Tab!C3:C702<=I9),Tab!C3:C702=C$9)))*(IF(D9="All",Rws,Tab!E3:E702=D$9))))

 

[Hapakaya]

Ok, how about

=LET(Rws,SEQUENCE(ROWS(Tab!C3:C702),,,0),FILTER(Tab!F3:Z702,(IF(B9="All",Rws,Tab!D3:D702=B$9))*(IF(C9="All",Rws,IF(C9="Range",(Tab!C3:C702>=H9)*(Tab!C3:C702<=I9),Tab!C3:C702=C$9)))*(IF(D9="All",Rws,Tab!E3:E702=D$9))))

You've done it again Fluff, thanks very much

 

[Fluff]

Glad to help & thanks for the feedback.