| Home |
| Search |
| Today's Posts |
|
#7
|
|||
|
|||
Ok, I have the following as my SUMPRODUCTS function:
=SUMPRODUCT(--('S:\Major Projects\6917-11 Gomez\revenue and cost tracking\Vessel Reports\[PS-MR-RP-DMR 01 Jul 05.xls]DMR'!$N$182:$Q$254="Fugro")) And I'm runing 3 of these on different parts of a workbook. 3 Different parts of the same workbook. But the problem is the 3rd time its doing it, it refused to look at the unopened workbook. Any suggestions? J. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart/Source Data update problem | Charts and Charting in Excel | |||
| update links - problem | Excel Discussion (Misc queries) | |||
| Update Links - Problem | Links and Linking in Excel | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Threaded Mode
