Thread: Help with SUM() Multiple cells from linked book

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

Hi braddach,

Is there a chance you can create a Named Range in your Linked workbook that includes
Q20,R20,T20,U20,U21,V20,V21,EH13
Then when your do your formula above you can use the named range in the formula.
See http://www.contextures.com/xlNames01.html

Another possibility would be to use an unrused cell on the Linked sheet to add the values in yoiur list and then return that singel cell's value in your formula above.