You will probably get some improvement from a Quad core chip running at the
same speed as a Duo (maybe 20-25 mins instead of 30?)

The improvement from multiple processors is very problem dependent, but you
could get an idea by seeing what the difference is between calculating using
only 1 core and calculating using 2 cores on your current system.
(Office Button--Excel Options--Advanced--Scoll down to Formulas
section--uncheck Enable multi-threaded calculation).

You could probably fairly easily get a much larger improvement by taking
some of the conditions out of your SUMPRODUCT formulae and putting them in
helper columns, or by sorting your data and doing the SUMPRODUCT
calculations on a sorted subset of data.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Mike" wrote in message
...
I use Office 2007 and a heavy user of Excel. My latest spreadsheet is 30mb,
with approx 1 million formulas. There are thousands of sumproducts. I will
be
duplicatin these spreadsheets for numerous locations.

It is now taking 30 minutes to calculate (I have set it to manual calc). I
have a new Lenovo T61 with 2.0 gb RAM and Intel Core Duo 2 CPU @2.2ghz. I
read a previuos post to go into arrays UDF and VBA but I dont have the
time
to learn that part fo the process.

Do you have experience on if I go to a new notebook with the Intel® CoreT2
Quad mobile processor chip. It is quite expensive but i need faster
processing. I don't want to spend the money if the impact is marginal.

Thanks in advance for any advice.

Mike