#VALUE error message

[Sculler6]

Hi I wonder if you can help.
I am putting together a spreadsheet with the following conditional statement:=+IF(D8>0,(((E8-D8)/365)*T8),0) where T8 is a sum derived from either the subject worksheet or another worksheet (=J$5*'% Summary '!F22 for example). Where the value derives from the current worksheet the formula works fine but when it comes from another worksheet i get the #VALUE error message.
Looking forward to hearing from you.
Many thanks Sculler6

[Dgp2012]

Hope this helps:

"=IF(D8>0,SUM((E8-D8)/365)*T8,0)"