If date is column A, cash column B and check column C)

sumproduct((a2:a200=date(2006,3,7))*(c2:c200=1)*(b 2:b200))

ALthough from your date format it is not clear if it is dd/mm/yy or
mm/dd/yy you may need to change the date to date(2006,7,3)

If the date was contained in a sperate cell say d1 the formula would
simplify to
sumproduct((a2:a200=d1)*(c2:c200=1)*(b2:b200))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=521676