As an example:

=SUMPRODUCT(--(A2:A1000="Wall"),--
(B2:B1000="10/1/04"+0),--(B2:B1000<="10/31/04"+0))

Where col. A is the order type and col. B is the order
date. You can also substitute the text strings for cell
references:

=SUMPRODUCT(--(A2:A1000=T1),--(B2:B1000=U1),--
(B2:B1000<=V1))

HTH
Jason
Atlanta, GA

-----Original Message-----
Might help more if I am more specific. I have a column
for order type (i.e,
Floor, Roof, Wall) then a column with the date that
order was created. I
would like to be able to identify how many orders
by "type" within a certain
date range. Is that possible? This would be something
that I want to generate
every month so I would probably be using first day of
month to last day of
month. Any help would be GREATLY appreciate!

"Jana" wrote:

I am trying to find a way to count the number of
values for a specific user
defined date range. HELP!
.