try a sumproduct formula
=sumproduct((a4:a22=a1)*(a4:a22<a2))

--
Don Guillett
SalesAid Software

"jrheinschm" wrote in message
...
I am a fairly new excel user. I am a contractor and wish to find out how
many
estimates we send out weekly from a dated list. We typically have many
estimates daily and wish to determine over a specific amount of time the
number of estimates.
I'm sure this is an easy one, once again fairly new at this.

Thanks much for the help