View Single Post
  #1   Report Post  
ghynes ghynes is offline
Junior Member
 
Posts: 3
Default SUMIF Returns a #VALUE error when external source is closed

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?