I would suggest breaking those links out into 10 seperate cells. Much easier
to diagnose problems. You could put them somewhere off to the side (say
Z1:Z10), maybe hide them so they don't distract user. Then your averaging
formula becomes:
=IF(SUM(Z1:Z10),AVERAGE(Z1:Z10),"")

--
Best Regards,

Luke M
"Ken" wrote in message
...
Excel2003 ... I do not usually work between WorkBooks ... I simply do not
like to ... :(

WB1 (Cell D3) ... AVERAGE Formula pulling from <= 10 different WB's (Cell
D3) ... (Works great as long as there is a "value" found)

Issue ... When other 10 WBs (Cell D3) is null ("") (hope I am using the
correct term?) ... My AVERAGE Formula WB1 (Cell D3) is returning the
"Div\0"
error.

My fix ... =if(iserror(Average etc etc),"",(Average etc etc)) ... issue
here
became length of my Formula because of Drives, Folder Trees & FileNames
etc
... Fix ok until Formula to looooooooooong.

Help from any intimate with Excel would be welcome ... Thanks ... Kha


--
Kha