Jeremy,

=SUMPRODUCT(--(AX2:AX61="OPEN"),--(B2:B61=DATE(2005,10,1)),--(B2:B61<=DATE(2005,12,31)))

or put your reference dates in two other cells say F1 & G1

=SUMPRODUCT(--(AX1:AX20="OPEN"),--(B1:B20=F1),--(B1:B20<=G1))

or don't use the "--" at all

=SUMPRODUCT((AX1:AX20="OPEN")*(B1:B20=F1)*(B1:B20 <=G1))

You were putting the "--" after the = sign in your conditions, this is
not necessary. Also, having the dates in " " doesn't seem to work
either.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=491906