The formula of sumproduct worked well!

Try to look at your date fomat Michelle to have exact value in betwee
quotation:

=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))

Regards
Roc

--
Roc
-----------------------------------------------------------------------
Rock's Profile: http://www.excelforum.com/member.php...fo&userid=2972
View this thread: http://www.excelforum.com/showthread.php?threadid=49458