How do I use advanced filters in excel?

[Guest]

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?

 

[Debra Dalgleish]

The date criterion may be causing the problem. Try entering the date in
a separate cell, then referring to it in the criteria cell, e.g.:

=">"&J1

where J1 contains the date.