|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 14th, 2009, 04:05 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF formula using data from another file
I am attempting to use a SUMIF formula that uses a criteria range and sum
range in another file. The formula works fine as long as both files. When the second file is closed the formula returns "#Value". Is there a way to get it to return the last known data until the link is updated without having to have both files open. I am running 2007 and the formula reads =SUMIF('filepath[filename]sheet name'!$A$13:$A$23,"CR", 'file path[file name]sheet name'!$S$13:$W$23) Thanks in advance 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode