Linking Workbooks

  • Thread starter Thread starter Jasmine
  • Start date Start date
J

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!
 
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
:-)
 
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!!
 
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

Jasmine said:
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



.
Click to expand...
Click to expand...
 
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
Click to expand...
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
Click to expand...
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!

.
Click to expand...
Click to expand...

.
Click to expand...
 
Back
Top