Chris,
I had a similar problem - Large database, many SP formulas, took over 30
minutes to recalculate. I'm now uising SUMIF with concatination The same
workbook recalculates in less than 5 minutes. Here's how:

For example, your original database has fields: A, B, code, quantity
Add a helper concatinated field AB (=RC[-2]&RC[-1]).
Apply a range name to each column field (use the field headers as names)
Now you're ready..
How many blues were sold in 2004? ... =SUMIF(AB,"=2004")
You might only want to sum items having code 2. You can sort the data so
that the code 2s appear at the top of the list, then re-set the range names
so that only the code 2s are included, then recalculate. Using a mix of these
techniques you can process your large databases in a fraction of the time
taken by SUMPRODUCT methods

A B AB code Quantity
Blue 2004 Blue2004 1 530,123
Red 2003 Red2003 1 23,456
Blue 2004 Blue2004 2 12,894

HTH

"chris" wrote:

Hi,

I have a sheet with many sumproducts and it takes forever to
recalculate.