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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif not Sumproduct 4
SUMIF vs SUM(IF(..)) vs SUMPRODUCT 7
Workbook causes calculation errors 2
How do I stop a recalculation in Excel? 6
Sumproduct formula 6
Indirect ref in array formulas 3
Sumproduct() usage 2
Sumproduct & Count formula 8

Back
Top