Linking Workbooks

[Jasmine]

I have a workbook with cells that are performing SUMIF
formulas to other workbooks. When I open the main workbook
and choose to update, if I don't have the other workbooks
open I get the #VALUE error in the cell. Is there a way
to have it update without having the other workbook open
or getting that error messsage? Thanks! You guys have
been a tremendous help!

 

[Frank Kabel]

Hi
SUMIF won't work on closed workbooks. But you may convert your SUMIF
formula to SUMPRODUCT. e.g.
=SUMIF(cond_range,condition,sum_range)
could be written as
=SUMPRODUCT(--(cond_range=condition),sum_range)

If you post your current sUMIF formula we could help you converting it

 

[Jasmine]

Here is the SUMIF formula I am using.

=SUMIF('C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'!
$A$1:$A$436,"Total Secondary Loans",'C:\Technical
Projects\Doc Prep\Pipeline\[Austin_Cathie.xls]Pipeline
Report'!$C$1:$C$436)

Thank you so much for the help!!

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--('C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'!$A$1:$A$436="Total
Secondary Loans"),'C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'!$C$1:$C$436)

--
Regards
Frank Kabel
Frankfurt, Germany

Here is the SUMIF formula I am using.

=SUMIF('C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'!
$A$1:$A$436,"Total Secondary Loans",'C:\Technical
Projects\Doc Prep\Pipeline\[Austin_Cathie.xls]Pipeline
Report'!$C$1:$C$436)

Thank you so much for the help!!

-----Original Message-----
Hi
SUMIF won't work on closed workbooks. But you may convert your SUMIF
formula to SUMPRODUCT. e.g.
=SUMIF(cond_range,condition,sum_range)
could be written as
=SUMPRODUCT(--(cond_range=condition),sum_range)

If you post your current sUMIF formula we could help you converting it


--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[Guest]

That worked! Thank you so much!!!!

-----Original Message-----
Hi
try
=SUMPRODUCT(--('C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'! $A$1:$A$436="Total
Secondary Loans"),'C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'! $C$1:$C$436)

--
Regards
Frank Kabel
Frankfurt, Germany

Here is the SUMIF formula I am using.

=SUMIF('C:\Technical Projects\Doc
Prep\Pipeline\[Austin_Cathie.xls]Pipeline Report'!
$A$1:$A$436,"Total Secondary Loans",'C:\Technical
Projects\Doc Prep\Pipeline\[Austin_Cathie.xls]Pipeline
Report'!$C$1:$C$436)

Thank you so much for the help!!

-----Original Message-----
Hi
SUMIF won't work on closed workbooks. But you may

convert
your SUMIF

formula to SUMPRODUCT. e.g.
=SUMIF(cond_range,condition,sum_range)
could be written as
=SUMPRODUCT(--(cond_range=condition),sum_range)

If you post your current sUMIF formula we could help

you
converting it

--
Regards
Frank Kabel
Frankfurt, Germany

I have a workbook with cells that are performing SUMIF
formulas to other workbooks. When I open the main workbook
and choose to update, if I don't have the other workbooks
open I get the #VALUE error in the cell. Is there a way
to have it update without having the other workbook open
or getting that error messsage? Thanks! You guys have
been a tremendous help!

.

.