Indirect.ext #value!

[Stuartf]

Hi,

Im using Indirect.ext to pull in info from closed workbooks, The
problem is that if a workbook dont exist it displays #VALUE!, im then
doing sum calculations on this pulled in info but because of the
#Value! the sums wont work. Anyone know a work around??

Cheers

 

[Stuartf]

Nevermind sumif has sorted it

I AM A DOUGHNUT

 

[Stuartf]

But it would be nice to display something else instead of #VALUE! Like
No Document ??? any suggestions??

 

[Roger Govier]

Hi Stuart

You could wrap your formula in an Iserror statement
=IF(ISERROR(your_formula),"No Document",your_formula)