How do I speed up recalcs when using lots of SUMPRODUCT formulas
 

I have a 33Mb spreadsheet in which I use SUMPRODUCT formulas to make multiple
criteria selections. This has a severe penalty in recalc time, now between
5-10 minutes. Is there a better way of achieving multiple criteria selections
without increasing recalc speed.

How do I speed up recalcs when using lots of SUMPRODUCT formulas
 

The definitive source for optimization:

http://www.decisionmodels.com/

Biff

"Peterdout" wrote in message
...
I have a 33Mb spreadsheet in which I use SUMPRODUCT formulas to make
multiple
criteria selections. This has a severe penalty in recalc time, now between
5-10 minutes. Is there a better way of achieving multiple criteria
selections
without increasing recalc speed.

How do I speed up recalcs when using lots of SUMPRODUCT formulas
 

I've seen other posts which show that SumIf is up to 40% faster.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=532501