Hi
use SUMPRODUCT. e.g.
=SUMPRODUCT(--(A1:A100="type1"),--(B1:B100=DATE(2004,1,1)),--(B1:B100<
=DATE(2004,12,31))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

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