Hi,
I have the following array Formula:
=SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,exp ensesamount,0),0))

The ranges mentioned in the formula are in the same workbook. What changes
should be made if the above name ranges are in another closed workbook?
Is this possible??

=SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,exp ensesamount,0),0))

=SUMPRODUCT(--('C:\myDirectory\[filename.xls]sheetname'!$A$2:$A$20=$A32),
--('C:\myDirectory\[filename.xls]sheetname'!$B$2:$B$20=E$3))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Khalil handal" <khhandal@yahoo.com> wrote in message
news:unKWpfPDJHA.5316@TK2MSFTNGP04.phx.gbl...
> Hi,
> I have the following array Formula:
> =SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,exp ensesamount,0),0))
>
> The ranges mentioned in the formula are in the same workbook. What changes
> should be made if the above name ranges are in another closed workbook?
> Is this possible??
>
>

Thanks.

"Bob Phillips" <bob.ngs@somewhere.com> wrote in message
news:e4efFEQDJHA.3392@TK2MSFTNGP03.phx.gbl...
> =SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,exp ensesamount,0),0))
>
> =SUMPRODUCT(--('C:\myDirectory\[filename.xls]sheetname'!$A$2:$A$20=$A32),
> --('C:\myDirectory\[filename.xls]sheetname'!$B$2:$B$20=E$3))
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
> "Khalil handal" <khhandal@yahoo.com> wrote in message
> news:unKWpfPDJHA.5316@TK2MSFTNGP04.phx.gbl...
>> Hi,
>> I have the following array Formula:
>> =SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,exp ensesamount,0),0))
>>
>> The ranges mentioned in the formula are in the same workbook. What
>> changes should be made if the above name ranges are in another closed
>> workbook?
>> Is this possible??
>>
>>
>
>