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.

SUMIF doesn't work when it is used to retrieve data from an external workbook
which is closed.

To see what I mean, open the workbook to which SUMIF connects, re-calculate,
and you should see your formula work.

I believe you can use SUMPRODUCT to get around this limitation. See he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Why doesn't SUMIF work if it refers to a closed, external workbook? I don't
know. I've never seen a satisfactory answer to that question.

Dave
--
Brevity is the soul of wit.


"Tina" wrote:

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.