Need "Div/0" Average Relief ...
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
|