SUMIF with external data

[Guest]

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.

 

[Guest]

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 here:
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