Try this:

Assuming you try to sum D2 to BC2 on your example.

=if($D$1:$BC$1=Now(),sum(D2:BC2),"")


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528713