Array Formula Adjustment

  • Thread starter Thread starter Khalil handal
  • Start date Start date
K

Khalil handal

Hi,
I have the following array Formula:
=SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,expensesamount,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,expensesamount,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)
 
Thanks.

Bob Phillips said:
=SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,expensesamount,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 said:
Hi,
I have the following array Formula:
=SUM(IF(expensescode=$A32,IF(expensesmonth=E$3,expensesamount,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??
Click to expand...
Click to expand...
 
Back
Top