Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not working after transfering to new workbook
Hello,
I created a workbook with formulas that work with links to other worksheets. When I copied it to a disk and saved it to my work computer the formulas do not work. Here is one of the formulas: =SUM{(('Procurement Gateway '!L3:L220="Won")*(MONTH('Procurement Gateway '!C3:C220)=1)*('Procurement Gateway '!J3:J220))} This works on the disk that I saved it on, but does not work on my compter at work. I get this error: #VALUE! What am I doing wrong? Any help is appreciated. Thanks! Mark Jackson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links w/in same workbook not working | Excel Discussion (Misc queries) | |||
Formulas not working | Excel Discussion (Misc queries) | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Formula's not working | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |