| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif function with remote cell references
I have used the sumif function with remote cell references. When I open the worksheet and click yes to update cell refences it returns errors in the cells but if I open the other worksheet the references update. Does anyone know how to use sumif and allow the remote references to be updated without opening the worksheet that contains the references. Thanks..... -- hennis ------------------------------------------------------------------------ hennis's Profile: http://www.excelforum.com/member.php...o&userid=26207 View this thread: http://www.excelforum.com/showthread...hreadid=395133 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Hiding a function value in a cell until function used | Excel Worksheet Functions | |||
| Function making cell really "empty" | Excel Worksheet Functions | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
Threaded Mode
