Are you comparing dates and times or just times? If dates and times

=SUMIF(D1:BC1,"="&NOW(),D2:BC2)

with times only


=SUMIF(D1:BC1,"="&MOD(NOW(),1),D2:BC2)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Gene Haines" wrote in message
...
renegan: Thanks for your response, however I got #VALUE! in the cell. Any
suggestions

"renegan" wrote:


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