Delay while entering data

[Guest]

I had a fairly clean workbook and all was well. Until, that is I started
adding formulas to perform calculations.

Most of my calculations are usiing the SUMPRODUCT function so I'm wondering
it that could be the problem. There is no VBA code in the worksheet, strickly
formulas.

System Specs are...

P4 3.2 GHz
1GB RAM
ATI x800 256MB video
60GB HDD

Kick ass laptop that can run any game out there but stumbles over data
calculations? Is this normal?

 

[Bob Phillips]

Depends upon how many, and the amount of data being evaluated, but yes, SP
can be quite resource hungry, but if you are doing that much calculating,
most functions will be resource hungry.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)