Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternative to SUMif when linking to closed workbooks
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF linking to closed workbooks. | Excel Discussion (Misc queries) | |||
Linking to a closed workbook | Excel Worksheet Functions | |||
alternative function to sumif | Excel Discussion (Misc queries) | |||
SUMIF Alternative? | Excel Worksheet Functions | |||
SUMIF Alternative? | Excel Discussion (Misc queries) |