I hope this code is self explanatory
Using Excel 2003
IF(HOUR(I1)<6,"",SUM(INDIRECT(CONCATENATE("'c:\Gold\",YEAR($I$1),"\[Logs",TEXT($I$1,"MM"),".xls]",DAY($I$1),"'!","$Q$20:$T$20"))))
Cell I1 holds NOW()
And it works super, but I need to SUM(Q20+R20+T20+U20+U21+V20+V21+EH13)
Thanks in advance
Bookmarks