Barb,
Try this,
=SUMPRODUCT((AL3:AL84=DATE(2006,3,1))*(AP3:AP84=6 ))
You were missing some parenthesis and when you put "3/1/2006" in, the
formula is looking for a text string equal to that but excel sees dates
as numbers not text. You could also type the date in another cell and
refer to it in the formula rather than using the DATE formula.
HTH
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=540337