| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula works only if other sheet is open
The formula below only updates the cell if the worksheet "Requisitions.xls"
is open. Otherwise, I get the message to update the link when I open the current worksheet but all that is displayed is #REF in each cell that the formula exists. Is there a way around this? I would like not to have to open the other workbook in order for the cells to update. I am summing all the values in Requisitions.xls column F where column H = the value in A2 and column G = 80801. Any help or suggestions you have are appreciated. =SUMPRODUCT(--([Requisitions.xls]Requisitions!$H$6:[Requisitions.xls]Requisitions!$H$6553=A2),--(MID([Requisitions.xls]Requisitions!$G$6:[Requisitions.xls]Requisitions!$G$6553,7,5)="80801"),[Requisitions.xls]Requisitions!$F$6:[Requisitions.xls]Requisitions!$F$6553) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Works won't open excel | Excel Discussion (Misc queries) | |||
| Was sent Excel doc but I have only Mic.Works, how to open? | Excel Discussion (Misc queries) | |||
| how do I open a works spredsheet in excel? | Excel Discussion (Misc queries) | |||
| How do i open excel doc in works? | Excel Discussion (Misc queries) | |||
| Open a .xls in micrsoft works sreadsheet | Excel Discussion (Misc queries) | |||
Threaded Mode
