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

[Peterdout]

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.

[Biff]

The definitive source for optimization:

http://www.decisionmodels.com/

Biff

"Peterdout" <[email protected]> wrote in message
news:[email protected]...
>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.

[Mikeopolo]

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

Regards
Mike