Hi
have you entered this formula as array formula?

--
Regards
Frank Kabel
Frankfurt, Germany

Mark Jackson wrote:
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