Type it in *exactly* as I showed but insert your path and sheet names.
Better if you follow Dave's suggestion and open the source file then you can
just point to the ranges and let Excel put all that path junk in for you.
Notice in my formula there is no "="& stuff!

=SUMPRODUCT((your_path_sheet!C6:C40=sheet!C13)*you r_path_sheet!D6:I40)


--
Biff
Microsoft Excel MVP


"A Taxed Mind" wrote in message
...
Thanks for your help Biff, but am afraid I just can't get it to work.

I tried the following and just got error messages.

SUMPRODUCT(('C:\Documents and Settings\Kärsälä\My Documents\Farm
Documents\Tax Documents and Spreadsheets\[2007 draft Tax
Documents.xls]Maa.
Tili'!$C$6:$C$40,"="&'Maa. Tulot'!C13),*'C:\Documents and
Settings\Kärsälä\My
Documents\Farm Documents\Tax Documents and Spreadsheets\[2007 draft Tax
Documents.xls]Maa. Tili'!$D$6:$I$40)

=SUMPRODUCT(('C:\Documents and Settings\Kärsälä\My Documents\Farm
Documents\Tax Documents and Spreadsheets\[2007 draft Tax
Documents.xls]Maa.
Tili'!C6:C40,)"="&'Maa. Tulot'!*C13),*'C:\Documents and
Settings\Kärsälä\My
Documents\Farm Documents\Tax Documents and Spreadsheets\[2007 draft Tax
Documents.xls]Maa. Tili'!D6:I40)

To be honest I still think I am not typing it correctly though. Can you
see
where I am going wrong?

Thanks again.


"T. Valko" wrote:

SUMPRODUCT should work:

=SUMPRODUCT((your_path_sheet!C6:C40=sheet!C13)*you r_path_sheet!D6:I40)

--
Biff
Microsoft Excel MVP


"A Taxed Mind" wrote in message
...
I know that I cannot use SUMif when linking to closed workbooks. I have
the
following formula which only works when the workbook is open:

=SUMIF('C:\Documents and Settings\Kärsälä\My Documents\Farm
Documents\Tax
Documents and Spreadsheets\[2007 draft Tax Documents.xls]Maa.
Tili'!$C$6:$C$40,"="&'Maa. Tulot'!C13,'C:\Documents and
Settings\Kärsälä\My
Documents\Farm Documents\Tax Documents and Spreadsheets\[2007 draft Tax
Documents.xls]Maa. Tili'!$D$6:$I$40)

What could I do to make this work? I have tried both SUMproduct and
SUM(if
but excel returned errors both times, presumably because my typing is
so
poor.

In case there is an easier way what I am trying to achieve is to match
the
text in the range on my summary sheet to the same text in the range in
the
annual sheets. When a match is found the adjacent value should be
returned.

Thanks in advance for your help.