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?

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
--
Brevity is the soul of wit.


"Scott" wrote:

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?

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

"Scott" wrote:

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?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Scott" wrote in message
...
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?