hi,
post your sumif formula. need more info that you profided. we are not
psychics.

Regards
FSt1


"ghynes" wrote:


Can you help me out with this? if works fine if the external source is
open but returns a #value if its closed. is there anyway of correcting
this?


--
ghynes