Error with SUMIF but not SUM(IF)

[Guest]

Can anyone tell me why I get an error (#VALUE) with
=SUMIF('C:\[doc.xls]sheet'!$M$4:$M$1000,"page",'C:\[doc.xls]sheet'!$G$4:$G$1000)

and when I use this I get correct answer :
{=SUM(IF('C:\[doc.xls]sheet'!$M$4:$M$1000="page",'C:\[doc.xls]sheet'!$G$4:$G$1000))}

Is SUMIF not able to work on multiple workbooks?

 

[Guest]

SUMIF won't work on external workbook links if those external workbooks are
not open when the calculation is done.

Neither SUM nor IF is subject to this constraint.

Dave

 

[Guest]

Why dont wild cards (e.g. "*pages") with the SUM(IF...) example below?

 

[Bernard Liengme]

They both work for me provided the second file is open.
I used
=SUMIF([junk4.xls]Sheet1!A1:A4,"a",[junk4.xls]Sheet1!B1:B4)
and
{=SUM(IF([junk4.xls]Sheet1!A1:A4="a",[junk4.xls]Sheet1!B1:B4))}

best wishes