View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tina tina is offline
external usenet poster
 
Posts: 139
Default SUMIF with external data

I am using a sumif function to sum data in a different file.
If I use the path to external data as x:\share\dir\file\cell..cell it works
OK, but if I replace x: with network name such as
\\nas\share\dir\file\cell.cell, it returns error.

Can anyone please tell me if this is a problem or I am supposed to use a
differnt syntax. I replaced the drive letter with network path in the menu
Edit Link Update Source.

Thanks much.