View Single Post
  #1   Report Post  
Mark Jackson
 
Posts: n/a
Default 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