Since understanding and using the sumproduct() function I use it extensively
in the design of some rather sophisticated spreadsheets. With several sheets
(in the WB) I utilize the Auto-Filter on the 4,000 to 5000 rows of data -
with amaybe 3 or 5 columns of the sumproduct() function in each row. It is
the availability of "multi-criteria" (which I need) that draws me to using
the Sumproduct.

The recalculation (using the tools options, calculation, automatic) is
terrible so I have set it to Manual, but anyway it is taking 1 0r 2 minutes
of "calculating" before the system is available to continue. Am I misusing
the function or is there an alternative that I could use and get the pay-back
of less calc time?

Tks in advance,

Jim May