Problem w/Adv Filter criteria range

[Helen]

I'm hoping you can help me figure out what I've done wrong with the criteria
range.

It is:

Age>=35; Age<=39; Annual>=27,000

What returned was a single record of a person age 41 with an annual of 17,500.

The list range included over 290 records and I know there is at least one
that meets the above criteria.

 

[Dave Peterson]

It's difficult to guess how you set up this criteria range.

But if that's part of the problem, I'd read the notes at Debra Dalgleish's site:
http://contextures.com/xladvfilter02.html