Thanks mikxtr, I am using "sumif", and you're right it does run more quickly

Regards

Andrew C

"mikxtr" wrote:


Another interesting issue that I've discovered is that Excel runs more quickly
with "sumif" than with "vlookup". If you have any vlookup statements, you
might
want to consider replacing them.

Mickey


"Andrew C" wrote:

I have constructed a spreadsheet with a number of formulae and lots of data,
and it seems to be taking ages to calculate. Has anyone any tips to speed up
the process.
Thanks