Hi Bernie,

When I entered the different part as you indicated, I get the #VALUE!
error. But when I use the double unary operator, i.e., =SUMPRODUCT(--(
), only the date part does not work.

Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=510555