=sumproduct((a2:a22=b1)*(a2:a22<b2))

--
Don Guillett
SalesAid Software

"Steve" wrote in message
...
Looking for just a basic formula to count between number or dates. Ex.
count between 1/2/2007 thru 1/31/07. I couldn't find anything in help
file.They show
or < ??
Any help would be appriciated

Steve