The specific reason why your formula did not work is because "01/03/2006" is
being evaluated as a TEXT string and not a numeric DATE.

Don's suggestion is the best option to use but here are a couple of others:

=SUMPRODUCT((Names!$A$2:$A$351=--"2006/01/03")*(Names!$E$2:$E$3510))

=SUMPRODUCT((Names!$A$2:$A$351=DATE(2006,1,3))*(Na mes!$E$2:$E$3510))

Biff

"y_not" wrote in
message ...

Works a treat


--
y_not
------------------------------------------------------------------------
y_not's Profile:
http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=541934