This should help: How to filter items by location or sub-folder
Specifically:
- Sub-Folder, No Match
- Full Path, Z:\(RAR|ZIP), Use wildcards
That should do what you need, when combined with your other criteria.
(Making this easier without needing an advanced filter is on our to-do list.)