CountIfs with between dates and two extra criteria that excludes blank cells in another column

[USAMax]

I have been using CountIfs with a lot of luck until I added one extra criteria that it ignores. Can anyone tell me why?

ORIGINAL FORMULA
=COUNTIFS(ADate, ">" & N$2, ADate, "<" & O$2, WBid, ">=" & 10000, WBid, "<30000")

NEW FORMULA
=COUNTIFS(ADate, ">" & N$2, ADate, "<" & O$2, WBid, ">=" & 10000, WBid, "<30000", AValue,"<>")

I have a column for dates that I need dates that fall between thus the => and <.

I need all Winning Bids that are >= 10,000 and < 30,000 that do not have an Assessed Value that is blank.

 

[USAMax]

After an hour of fighting with this I posted this question.

Five minutes after posting I found my error in the Named Range for AValue! UG!!

Thank you,