Thread: Sumif formula returning #VALUE when source worksheet is not open
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gillian Gillian is offline
external usenet poster
  
Posts: 14
Default Sumif formula returning #VALUE when source worksheet is not open
Hi,
In Workbook1 have a sumif formula which is summing data from Workbook 2.
When Workbook 2 is open the formula works fine. When Workbook 2 is closed
the formula returns #VALUE error.
Can you help?
thanks


--
GJ
Reply With QuoteReply With Quote