It depends.
At this link:
http://msdn2.microsoft.com/en-us/library/aa730921.aspx
there are some VBA routines that will let you time the calculations. You'll
find the code about 1/4 of the way down.
Biff
"Neophyte" wrote in message
...
I finally got my sum(if) based on more than one condition to work but it
takes my 1.8 Ghz chip 7 or 10 minutes to calculate the workbook with the
array formulas in 2003 Excel. Is Sumproduct any faster or do I just need to
use the free time to do something else?
Thanks,
Lee