I have a worksheet that is pulling data from another sheet saved, but i get values unless i actually have the other sheet pulled up. Here is a function that does that.
=SUMIF([April12SA_PATH_EXT.xls]SA_PATH_EXT!$P$11:$P$1000,$C6,[April12SA_PATH_EXT.xls]SA_PATH_EXT!$F$11:$F$1000)
Anyone have an idea to fix this?
Thanks
Bookmarks