Indirect.ext #value!
 

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
------------------------------------------------------------------------
Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535
View this thread: http://www.excelforum.com/showthread...hreadid=545007

Indirect.ext #value!
 

Nevermind sumif has sorted it

I AM A DOUGHNUT


--
Stuartf
------------------------------------------------------------------------
Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535
View this thread: http://www.excelforum.com/showthread...hreadid=545007

Indirect.ext #value!
 

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


--
Stuartf
------------------------------------------------------------------------
Stuartf's Profile: http://www.excelforum.com/member.php...o&userid=34535
View this thread: http://www.excelforum.com/showthread...hreadid=545007

Indirect.ext #value!
 

Hi Stuart

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

--
Regards

Roger Govier


"Stuartf" wrote
in message ...

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


--
Stuartf
------------------------------------------------------------------------
Stuartf's Profile:
http://www.excelforum.com/member.php...o&userid=34535
View this thread:
http://www.excelforum.com/showthread...hreadid=545007