I am using an advanced filter to and it is only filtering one part of of
input. How do i get it to filter all of my input?

Products that begin with letter A and units greater than 7,500 or product
equal to Zebram date greather than 12/31/2004, and dollars less than 3,000.
It is filtering the Zebra part not the first part of or statment.

What do i need to do?